• Hi

    I tried to paste your script to empty a database into a query in SQL 2008 management studio and I keep getting the following set of errors:

    Msg 102, Level 15, State 1, Line 74

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 75

    Incorrect syntax near '?'.

    This is the lfirst line inside the While.. loop for cursor c. I have tried to change it, and nothing works unless I remove all lines inside the while loop (which is obviously defeating the purpose of the script!). Can you please suggest what I am doing wrong? I would like to use your script to see if I can empty my database just before deploying it

    Luis Valentim