Home Forums Programming General Execute a stored procedure from a batch file RE: Execute a stored procedure from a batch file

  • Hi,

    Am getting the following entry in my log file when i put echo before

    %OpMode% %msISQL% Some_File.sql:

    CALL C:\sql\core\MS_ISQL_Driver.bat Some_File.sql

    executing MS_ISQL_Driver.bat with input file Some_File.sql

    ---- START ERROR HANDLING -----

    BATCH TERMINATED by unexpected error "in SQL Script Some_File.sql". Skipping remaining batch.

    I think there is problem with the Some_File.sql, means, my way of executing the stored procedure might be wrong..

    I have entry as:

    execute [dbo].[Stored_Procedure_Name] 1,0,0,''

    Is this right?