Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer”

Start -> Programs -> MS SQL Server -> Query Analyzer

Connect to the database that you’re running the script on.

Then open the SQL file using File -> Open

Once it is open, you can execute the file by pressing F5.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state When restoring multiple backups, each backup needs...

Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...

Change the DNS servers for the network interfaces on my Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Change the root password for a *nix server

In order to change the root password login to the server as root and type the following, then...