Handling Response from a call to Stored Procedure via Batch File

• Arun_dBZ

  Grasshopper

  Points: 13

  More actions

  May 4, 2015 at 5:44 am

  #99998

  Hi,

  I am very New to the SQL SERVER and its various jargons. This is probably a very basic query but looking around was not of much help.

  I am Trying to execute and handle response from a call to stored proc but unable to handle the responses correctly.

  Below is a snippet of the code.

  osql /Uusername /Ppassword /S ServerName /d DbName /q "exit(exec Stored_Proc)"

  Echo %ErrorLevel%

  The process i am trying to achieve is to to skip processing of further steps if the call to stored proc was a failure.

  Upon executed the above code, the ErrorLevel -100 is displayed even though the call went thru and the stored proc processing is happening correctly. I am not sure about how to go about handling this response or if this actually the response from the call being made.

  Googling around gave me details about what -100 is (Error encountered prior to selecting return value) but could not find anything about to how to fix it.

  If any of you could please provide some directions on what is going wrong or what corrections i need to make, it would reallu be very helpfull.

  Thanks Very Much for your Help,

  Arun.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  May 4, 2015 at 7:06 am

  #1795337

  This thread discusses the topic in depth: http://www.sqlservercentral.com/Forums/Topic1188295-392-1.aspx

  Don't use osql: it's old. The replacement is sqlcmd.

  -- Gianluca Sartori