Execute stored procedure from batch file

Question

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

Answer 1

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