Error running insert statement in a database

Question

Post reply

Error running insert statement in a database

Kyle Schlapkohl

SSCrazy

Points: 2463
More actions
August 15, 2007 at 7:25 am

#180311

When I run this query against PFGDSMRISSQLQ1 in Server manager 2005:
use
INSERT INTO dbo.
(, , )
VALUES (12598,2900,1.00)
I get this error:
Msg 8624, Level 16, State 1, Line 5
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
Can someone please help. Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sql Junkie-204042 Hall of Fame Points: 3874 More actions · Answer 1

You may need to apply a hotfix to your server

http://support.microsoft.com/kb/931329

Kyle Schlapkohl SSCrazy Points: 2463 More actions · Answer 2

I looked over the link you sent me and the state is wrong. Mine is state 1 and the link above references a state 116. "The query processor could not produce a query plan" There is nothing about problems producing a query plan.

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 3

Kyle -

Modify your insert statement to include the column names in your table (e.g. insert table (column1, column2, column3) and let us know the results... I can't even get your query to execute on my machine (get an invalid syntax near ',' error).

Joe