Execute stored procedure from batch file

Question

How would you execute a stored procedure in SQL Server (using windows authentication) from a batch file?

score 34 · Accepted Answer · answered Oct 19 '12 at 18:37

34

If you are using Sql Server 2005+, you can use sqlcmd utility.

Example:

sqlcmd -Q "exec storedProcName" -S YourServer -d YourDatabase -o C:\yourOutput.txt

answered Oct 19 '12 at 18:37

dugas

and you put this in a .bat file and run using cmd? – Nitrodbz Oct 19 '12 at 18:54
1

Yes, you can execute from a .bat file. – dugas Oct 19 '12 at 19:25

score 5 · Answer 2 · answered Oct 19 '12 at 18:38

5

With SQL Server 2005 and above you can use sqlcmd.exe. More info about how to use it:

answered Oct 19 '12 at 18:38

Robin V.

score 4 · Answer 3 · answered Oct 19 '12 at 18:39

4

You can use sqlcmd.exe See: MSDN usages

answered Oct 19 '12 at 18:39

danseery

3 Answers3