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 |
|
Mannga
Yak Posting Veteran
70 Posts |
 Posted - 2003-11-12 : 01:49:45
|
| Morning All,Is there anyway to setup a DOS batch file that will execute SQL scripts for me?We are trying to automate our rollout process completely and this is the last sticking point.Is there anyway to execute scripts without using SQL Manager or Query Analyzer?Cheers,Gavin |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-12 : 02:09:34
|
yes, look up the "osql" utility in the Books Online. osql lets you run sql statements from the command line, great for automating roll-outs! It is distributed with all versions of SQL Server and MSDE.Owais
Where there's a will, I want to be in it. |
 |
|
|
Mannga
Yak Posting Veteran
70 Posts |
Posted - 2003-11-12 : 02:56:51
|
Thank you o' wise and Aged Yak Warrior  .....Thanks for the quick response... |
|
|
|
|
|
|
Execute SQL Script from Command Line