Q. How do I execute a SQL script (.sql file) on my MS-SQL database server under Windows Sever 2003?
A. You can easily run any .sql file on MS-SQL database server using the Query Analyzer tool.
How can I execute a SQL script (.sql file) on my SQL Server ?
Open the Query Analyzer by visiting Start â†’ Programs â†’ MS SQL Server â†’ Query Analyzer
Once opened, connect to the database that you are wish running the script on.
Next, open the SQL file using File â†’ Open option. Select .sql file.
Once it is open, you can execute the file by pressing F5.