How to: Deploy a C++ SQL Server Project to a Server
To deploy a C++ SQL Server Project (or stored procedure), use the Deploy command. This command is available on the Build menu and on the shortcut menu of the solution in Solution Explorer.
To deploy a C++ class library to a server
Open your C++ SQL Server Project.
On the Build menu, click Deploy <Solutionname>.
— or —
In Solution Explorer, right-click your solution and then click Deploy on the shortcut menu.
The Output window contains information about whether the deployment of your stored procedure succeeded or failed.
Project Settings for Deployment
You might want to modify the permission level of the stored procedure that you want to deploy. By default, Visual C++ SQL Server project property settings are set up to deploy stored procedures that have the SAFE permissions level. The following procedures describe how to modify your project property settings so that you can deploy stored procedures that have different permission levels.
To set up safe SQL server projects for deployment
Open your C++ SQL Server Project.
Open the property pages dialog box for your project.
Under the Configuration Properties node, select the General page.
Set the Common Language Runtime support property to Safe MSIL Common Language Runtime Support (/clr:safe).
Set the Assembly Permission Level property to Safe.
See Also
Tasks
How to: Open Project Property Pages
How to: Create a SQL Server Project (C+)
How to: Add a SQL Server 2005 Reference