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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Call Sql script from sql script ??

Author  Topic 

suls
Starting Member

5 Posts

Posted - 2006-12-08 : 05:50:47
Hi All

Hopefully an easy one but dammed if I can find the answer.

I have 4 SQL scripts

Create tables.sql
Create views.sql
Create procs.sql
Create Triggers.sql

How do I create a create all.sql that runs each of the other scripts in turn ?

TIA

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-08 : 06:06:13
Create an MS-Dos batch file which will use OSQL to run each of these scripts and run the batch file.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -