<div>
basically...<br />
<br />
osql.exe -dDatabaseName -E -iInputfile -oOutputfile -SserverName<br />
<br />
<br />
for the create database specify Master or Tempdb as the database<br />
<br />
use -E for a trusted connection or -Uuserid -Ppassword for &nbsp;a sql server login...<br />
<br />
invoke osql 3 times once for each script type...<br />
<br />

</div>


basically...

osql.exe -dDatabaseName -E -iInputfile -oOutputfile -SserverName


for the create database specify Master or Tempdb as the database

use -E for a trusted connection or -Uuserid -Ppassword for  a sql server login...

invoke osql 3 times once for each script type...



<div>
OK, so I can create a .bat file to do this. But isn't there a way to say it in a sql-script file?<br />
Some kind of &lt;execute file&gt; statement or something?
</div>


OK, so I can create a .bat file to do this. But isn't there a way to say it in a sql-script file?
Some kind of <execute file> statement or something?

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I want to create a script that says:<br />
<br />
- Run scriptfile 1 &nbsp;(create database script)<br />
- Run scriptfile 2 &nbsp;(create stored procedures script)<br />
- Run scriptfile 3 &nbsp;(fill database script)<br />
<br />
What is the syntax for this?
</div>
</div>


Hi All,

I want to create a script that says:

- Run scriptfile 1  (create database script)
- Run scriptfile 2  (create stored procedures script)
- Run scriptfile 3  (fill database script)

What is the syntax for this?

Query Analyzer: Run sequence of files

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.