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.

  • Email, SSL
  • 0 Gebruikers die dit nuttig vonden
Was dit antwoord nuttig?

Related Articles

Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following...

How to Install MRTG

Solution Steps for MRTG installation are documented as MRTG Installation Make sure MRTG is NOT...

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...

redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect...

Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...