LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » Stored Procedures, Triggers, & Functions » getting an error while executing an procedure

getting an error while executing an procedure

Options

Previous Topic · Next Topic

sharath

Posted: Tuesday, April 22, 2008 2:14:40 AM

Rank: Newbie

Joined: 4/22/2008
Posts: 1
Points: 3
Where do you live?: india

hi to all ,
while i am executing a procedure i am getting the following message and i am not getting out put.
here i am passing an number and the data type is varchar.let me know why this error is comming ?

the error is as follows

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

Scott Whigham

Posted: Tuesday, April 22, 2008 6:10:02 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX

Well, a quick Google comes up with a hotfix for that error: http://support.microsoft.com/kb/917888. Have you seen that hotfix or installed it? I've not seen that error before.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.