Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-01 : 08:25:13
|
| Kim writes "First of all, I am a newbie so please be patient with me. I have a DB setup on a SQL Server 2000 box. I have a stored procedure that I would like to execute using a windows batch file. I am not sure if this can be done and if so, how to do it. Let me know what information you need to help me accomplish this. Here's a little that may help. Server name: IDC-ServerDB name: Alphausername: Halpassword: xxxxxstored procedure name: sp_testI may have the batch file reside on the SQL server but for testing, the batch file will be run from a different machine.Thank you in advance for your help and expertise." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-01 : 08:26:16
|
| Take a look in Books Online for "osql utility", it's a command-line utility for running SQL files or simple queries. Books Online is installed in the same program folder and Start menu as the other SQL Server programs. |
 |
|
|
|
|
|
Exec a stored procedure using a windows batch file