Firing VBscript to connect to database and restore from a snapshot HELP!
Hi guys. Very new to all this but this is what I've got so far... 1. I can connect to a DB using a little VBScript. Cool. I want to run the following SQL to revert the database to a s...
- Hi Sean,
One thing you can do.
Create a .sql file for the query. (Test.sql)
You can execute this query silently using sqlcmd utility. (Please refer help file to run the .sql file silently in SQL 2008 R2)
Now , you can create a batch which will execute this query & you can invoke the .bat file using vbscript function using "wscript.shell" object.
This could be the longer way of doing it , but you can skip the creation of batch file part and use vbscript funtion which will create the sqlcmd command and execute it.
I hope this has been of some help.
