Thank this author by sharing:
By John Bevan, 2012/09/20
The code includes example usage. Here I've created a table to host the VBScript code & settings such as whether the script is interactive, or if it should timeout after a given period. However the script should be easy to alter to run ad hoc scripts also (just amend sp_RunScript from taking an id and fetching the script/parameters to moving the @script, @batchMode, @timeoutSecs variables to the function's parameter list.
The code runs on the host server under the database instance's service account.
script
Need Automated Script
drop script
Script component
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
