Running a Script in Microsoft SQL Server
To run a script in Microsoft SQL Server 2008
-
Connect to the Microsoft SQL Server computer using an administrator account.
-
Start the Microsoft SQL Server Management Studio (on the Windows taskbar, select Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
-
In the Connect to Server dialog box, in Server name, select the name of your SQL server instance, and then click Connect.
-
In Microsoft SQL Server Management Studio, on the menu, select File > Open > File.
-
In the Open File dialog box, browse for the script file, and then click OK.
Example: The Analytics database creation and migration scripts are available on the Coveo server in the [.Net_Front-End_Path]\Web\Analytics\Scripts\ folder.
-
On the SQL Editor toolbar, select the appropriate database, and then click Execute to run the script.
A message appears at the bottom of the Microsoft SQL Server Management Studio window to indicate that the execution of the script completed successfully.