|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
08-13-2008
| #1 (permalink) |
| | Get a SQL Script Hi, Is there a way to use VBScript to query a database, get a list of sp's and then script the sp if the create date is beyond a certain date. I think I can use openschema to get a list of sp's but i dont seem to be able to run the sp_helptext stored procedure to get the text. So i was wondering whether sql has an api to allow you to ask it to script an sp remotely? thanks Robert |
My System Specs |
|
08-13-2008
| #2 (permalink) |
| | RE: Get a SQL Script OK please ignore that .. the answer is simple .. just use cmdtext to run sp_helptext rather than adcmdstoredproc.. because sphelptext is an sp in master and not in the db concerned Robert "Robert" wrote: Quote: > Hi, > > Is there a way to use VBScript to query a database, get a list of sp's and > then script the sp if the create date is beyond a certain date. > > I think I can use openschema to get a list of sp's but i dont seem to be > able to run the sp_helptext stored procedure to get the text. So i was > wondering whether sql has an api to allow you to ask it to script an sp > remotely? > > thanks > > Robert |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Logon Script Causing Laptops To Hang - Problems in script? | VB Script | |||
| problem passing args to script 'There is no script engine for file extenstion' | VB Script | |||
| Include another script, keep variables in included script? | PowerShell | |||
| Script file has 'OS Handle' error when run from script | PowerShell | |||
| Can you drag-n-drop a file on top of a PS script to run the script? | PowerShell | |||
