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 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Related Articles

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

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

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

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to...

Enable the full text indexing for a MSSQL database

Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs...

Copy MySQL database to another server through shell?

Copying MySQL Databases to another server If you are using MySQL 3.23 or later, you can copy the...