Executing Stored procedure From VB Script

• Gaurav-934012

  Old Hand

  Points: 361

  More actions

  March 5, 2009 at 9:57 am

  #197676

  Hi All

  I have couple of stored procedure that I want to use without Running SSMS (management studio). These Stored procedures works fine. I was wondering Is there a way I can call these Stored procedures In VB script, So I just need to run these scripts at command prompt which in turn execute the Stored Procedures.

  Gaurav

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  March 5, 2009 at 10:12 am

  #954178

  same idea as here:

  http://support.microsoft.com/kb/164485

  Set the variables, create the objects, make the call. ASP uses VBScript, so the code is the same, minus the <! stuff.