Running a Stored Procedure from a Batch File

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Take a look at Osql.exe, or bcp in sql server books online

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 2

Or, run VBScript (either from batch file, or instead of batch file. Then, either:

Create ADO connection object and run the Execute method. See "ADO Samples" in BOL.
Create SQLDMO object and run ExecuteImmediate or ExecuteWithResults methods (depending on sproc results).

Hope this helps

Mark

Ed Berk Grasshopper Points: 11 More actions · Answer 3

Or, simply put the line below in a batch file:

isql /U sql_username /P sql_password /S servername /i k:\filename.sql /o k:\logfile.log

And put yout T-SQL commands in the filename.sql file.

David Burrows SSC Guru Points: 65141 More actions · Answer 4

or if you do not wish to use an input file then

osql -Q "EXEC SP_FormatName 'TEST_TABLE'" /U sql_username /P sql_password /S servername /o logfilename

Far away is close at hand in the images of elsewhere.
Anon.