Post reply

Delete Database confirmation in Script

  • August 30, 2006 at 10:20 pm

    #153164

    Hi,

    I have written a script to delete the database during uninstallation of the product.

    OSQL -E -S .\SQLExpress -d MASTER -w 200 -n -b -Q "DROP DATABASE Sample" -o "DeleteDb.txt"

    But before the deletion I would like to ask the confirmation. How do I do that?

    -Vidhya

     

  • August 31, 2006 at 11:49 am

    #657886

    Drop database doesnot have any paramter(s) other than the database Name. So if you want a prompt then it has to be added to batch file or script before calling the Drop database statement.

    Thanks

    Sreejith

  • September 1, 2006 at 12:17 am

    #657962

    Thank you for the reply. will try adding the prompt in the script and check out

     

    -Vidhya

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply