getting an error while executing an procedure - Stored Procedures, Triggers, & Functions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » 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
Location: 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: 345
Points: 748
Location: 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.