How to run a .sql file in SQL Server 2005 Express Edition.

[Paramhans Dubey]

Hi All, I have a .sql file with all my queries written in it. Now I want to know, Is it possible to run this sql file in SQL Server 2005 Express Edition like we can do in Oracle? If it is possible then tell me how to do it? Thanx in advance for any kind of help. Regards, Paramhans Dubey.

[originSH]

You'll need the Sql Server Express Management Studio if you want the official IDE to do this stuff in.

[Craster]

You certainly can. Use the sqlcmd.exe[^] command line utility.

[Pete OHanlon]

You can run them using the osql tool. Use osql -S (local)\Server -i <<filename.sql>>. There are other switches you may need to set such as the user id and password. To find out what the options are, type in osql /?.

Deja View - the feeling that you've seen this post before.