How to run SQL scripts in SQL Server Management Studio

Upgrades and configurations sometimes require SQL scripts to be run against the Maytas database in SQL Server Management Studio. This must be performed on a machine which has Management Studio installed and has access to the SQL server where the Maytas database is held.

To run a script:

1. Start Management Studio by going to Start | All Programs | Microsoft SQL Server [version] | SQL Server Management Studio.

2. Connect as the Maytas3 user to the SQL server where the Maytas database is held. Please note that you should use SQL Server Authentication, as certain scripts will not run correctly using Windows authentication.

   

3. Go to File | Open | File…
4. Browse to and select the SQL script you wish to run and click Open.
5. Ensure the Maytas database is selected in the dropdown list at the top left of the screen.
6. Click Execute.

The script will now be run.