Running a Script in Microsoft SQL Server

You may need to run a script in a Microsoft SQL Server for example to create the tables in the Coveo Analytics database.

To run a script in Microsoft SQL Server 2008

1. Connect to the Microsoft SQL Server computer using an administrator account.

2. Start the Microsoft SQL Server Management Studio (on the Windows taskbar, select Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).

3. In the Connect to Server dialog box, in Server name, select the name of your SQL server instance, and then click Connect.

   

4. In Microsoft SQL Server Management Studio, on the menu, select File > Open > File.

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

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