How to run .vbs file inside stored procedure

• mizan700

  SSC Enthusiast

  Points: 193

  More actions

  August 2, 2016 at 3:00 am

  #328768

  Hi, Expert,

  I want to execute some .vbs/.bat files inside stored procedure. Would you please assist me How to do this?

  Regards,

  Mizan

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  August 2, 2016 at 3:17 am

  #1893158

  you can use xp_cmdshell to run batch files.

  But you need to make sure that batch file wont have worse effect on system and databases.

  Thank You.

  Regards,
  Raghavender Chavva