nigelevenden (11/26/2008)
Hi, Please forgive me sounding silly but I am a bit of a novice...I am getting the follwoing errors. Are these as a result of my copying and pasting the script..? If so it might take me an age to try and debug as I can't see anything wrong with the transact SQL. Any tips please..?
Msg 102, Level 15, State 1, Line 22
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 27
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 28
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Line 29
Must declare the scalar variable "@objid".
Msg 102, Level 15, State 1, Line 31
Incorrect syntax near '?'.
The issue is due to the special characters that are generated in the editor. What I would request you is to copy the script and paste it in a note pad and you just replace the special characters that are shown on each line where a tab is used and replace them. It should get compiled without any issues.
Prasad Bhogadi
www.inforaise.com