Calling the Extended Stored Procedure

  • Article

Feature Only in Enterprise Editions   Using the Extended Stored Procedure Wizard to create an extended stored procedure is supported only in Visual C++ Enterprise Editions. For more information, see .

One way you can call the new extended stored procedure is from an SQL script file.

To call an extended stored procedure

  1. Make sure the active project is set to the database project created in the previous step.

  2. Choose New from the File menu.

  3. Click the Files tab, then choose SQL Script File from the list of file types. You will now have a blank script file in the Visual C++ editor. If the extended stored procedure's name is xp_MyXp, the following code would cause the extended stored procedure to be executed:

    EXEC xp_MyXp

  4. To run the script, right-click on the editor window and choose Run from the shortcut menu.

If the extended stored procedure produces any output, you can view the output in the Results pane.

Note   SQL Server does not perform parameter checking on extended stored procedures. It is up to the caller of the extended stored procedure to know the required parameters and then pass them accordingly.