Execute the CLR Stored Procedure manually

The default values can be supplied through the Studio interface. For more information on setting default values, see Add and configure a CLR Stored Procedure Host connection.

To execute procedure in SQL Server Management studio

1. Open Microsoft SQL Server Management Studio on the server that runs your project.

2. In SQL Server Management Studio. expand the Databases folder and then the [Project]Data folder.

3. Look for the Programmability folder and then the Stored Procedures folder.

   

4. In the Stored Procedures folder, locate the two stored procedures.

   

5. Right-click a stored procedure and click Execute Stored Procedure. The Execute Procedure dialog box opens.

6. Enter values, as needed. Select Pass Null to allow no value for a parameter. The module and location parameters are mandatory.

   

7. Click OK to execute stored procedure.

Related topics

• Install the CLR Stored Procedure

• Modify the default CLR Stored Procedure parameters