Register the script files in SQL Server

After generating the install files, register the script files in the SQL Server.

To register script in SQL Server

1. In SQL Server Management Studio, on the File menu, point to Open and click File.

2. In the Open File dialog box, browse to the install script file.

   

3. Click Open. The SQL script appears in a tabbed window pane.

   

4. Change some default settings in the SQL script.

   

5. When you have made these changes, click Execute.

6. You can navigate in the SQL explorer view to verify this is successful .

   Databases > [YourDatabase] > Programmability > StoredProcedures > dbo.GetDataByLocationV200806

   

Related topics

• Generate an install script package

• Install the CLR Stored Procedure

• Modify the default CLR Store Procedure parameters