• 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'.