I have to execute an SP from .bat file. What I have done is, I have created a .bat file with the following entry:
%OpMode% %msISQL% Some_File.sql
The "Some_File.sql" file contains the following execute statement:
execute [dbo].[Stored_Proc_Name] 1,0,0,''
The connection parameters for the database are in another .bat file.
When I execute the .bat file, am getting the following error:
Msg 170, Level 15, State 1, Server SERVER_NAME, Line 1
Line 1: Incorrect syntax near 'ÿ'.
Any help is appreciated..