Stored Procedure Silly bug...help !

[fixthebug2003]

I keep getting this stupid error in MS Sql Server, where I am developing a Srored procedure!
When I press the "Check Syntax" Button..it says

"Error 156: The Identifier that starts with '.select stmt...' is too long. Maximum length is 128".


I see the same stored procedure in another database, and it is fine.!

Fixthebug2003

 

[philhege]

Fix,

The "identifier" refers to a table name. You have a glitch somewhere in the code that makes SQL think a piece of the code is an object name. Check your dot notation, etc.


HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

 

[JamesJKusch]

its the period at tbe begining of tbe select statment that is causing the issue ... '.select stmt...'. Remove the initial period and all should be fine.


J. Kusch