- In Visual Studio, make your SQL Server Database Project the active project.
- Start OpenESQL Assistant.
- Right-click over the toolbar and select
Add SP to SQLCLR project.
- If the stored procedure already exists, OpenESQL prompts you to replace the program in the project.
To ensure that the program compiles properly and deploys the appropriate runtime, set the following properties, found on the