To add or update a SQL CLR Stored Procedure

  1. In Visual Studio, make your SQL Server Database Project the active project.
  2. Start OpenESQL Assistant.
  3. Right-click over the toolbar and select Add SP to SQLCLR project.
  4. If the stored procedure already exists, OpenESQL prompts you to replace the program in the project.
Note: To ensure that the program compiles properly and deploys the appropriate run-time, set the following properties, found on the project properties SQL tab:
ESQL Preprocessor OpenESQL
DBMAN Directive ADO