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
Parent topic: OpenESQL Assistant
Parent topic: SQL Server COBOL Stored Procedures
Related concepts
Generating a SQL CLR Stored Procedure Query
Testing a SQL CLR Stored Procedure Query
Related tasks
To create a SQL CLR stored procedure query
To create a SQL Server database project
To generate a SQL CLR stored procedure