Publish the LookupEMP Stored Procedure to SQL Server

Takes you through the process of publishing the LookupEMP stored procedure to your local SQL Server instance.
  1. In the Solution Explorer, right-click the SQLServerSP.Publish project; then select Publish.

    Enterprise Developer builds the project and then invokes the Publish Database dialog box.

  2. On the Publish Database dialog box, click Edit.
  3. On the History tab under Recent Connections, select SQLCLR_Test; then click OK.
  4. On the Publish Database dialog box, click Publish.

    When the publishing process is complete, the Data Tools Operations window shows a status of Publish Completed Successfully.