How can I Execute Stored Procedure from Batch File in SQLServer 2005/2008?

• sarvade.inder

  Old Hand

  Points: 352

  More actions

  May 15, 2011 at 12:11 pm

  #98203

  Greetings!!!

  How can I Execute Stored Procedure from Batch File in SQLServer 2005/2008?

• Ludwig Guevara

  SSC Veteran

  Points: 225

  More actions

  May 16, 2011 at 1:32 pm

  #1325428

  Hi,

  Use the sqlcmd utility

  http://msdn.microsoft.com/en-us/library/ms180944.aspx

  Batch file:

  echo Running badscript.sql

  sqlcmd -i script.sql -b -o out.log

  script.sql file has all the parameters to call the stored procedure