Hi Everyone,
I am trying to execute this script as it is on a SQL 2000 and 2008. I am getting all sort errors. Please see below. Can anyone help please
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Line 11
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 30
Line 30: Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Line 37
Must declare the variable '@sql'.
Msg 137, Level 15, State 2, Line 38
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 41
Line 41: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 53
Line 53: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 60
Line 60: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 65
Line 65: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 79
Line 79: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 111
Line 111: Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Line 112
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 116
Line 116: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 118
Line 118: Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Line 124
Must declare the variable '@sql'.
Msg 156, Level 15, State 1, Line 132
Incorrect syntax near the keyword 'END'.
Msg 170, Level 15, State 1, Line 136
Line 136: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 143
Line 143: Incorrect syntax near 'DSP'.
Msg 170, Level 15, State 1, Line 144
Line 144: Incorrect syntax near 'DSP'.
Msg 170, Level 15, State 1, Line 145
Line 145: Incorrect syntax near 'DSP'.