Creating an Extended Stored Procedure

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 Visual C++ Editions.

You can easily create SQL Server extended stored procedures (XPROC) with the Extended Stored Procedure Wizard in Visual C++. An extended stored procedure is an extern C function, exported from a Win32 DLL, that you can call from within SQL Server. An extended stored procedure is called like a stored procedure but is run on the server like any compiled process. Unlike an SQL Server stored procedure, which requires you to use SQL statements, an extended stored procedure lets you use Win32 APIs and Open Data Services (ODS) Open Data Services calls.

For more information, search the Knowledge Base for an article on extended stored procedures.

What do you want to know more about?

Using the Wizard to Create an Extended Stored Procedure

Registering the Extended Stored Procedure

Calling the Extended Stored Procedure

Adding Functionality to the Extended Stored Procedure

Debugging an Extended Stored Procedure