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 Корисниците го најдоа ова како корисно
Дали Ви помогна овој одговор?

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

Fix Lame Nameserver Error

A lame server, is one that is specifed at the registrar to be authoritative for a domain, but...

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

Manage Query Cache

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

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