Registering an Extended Stored Procedure
The process of creating an extended stored procedure is known as registering the extended stored procedure. This registration allows SQL Server to recognize the functionality that's provided in the DLL. To add the extended stored procedure to SQL Server, someone with system administrator–level privileges must run the sp_addextendedproc system stored procedure, specifying the name of the DLL and the function in the DLL that is the extended stored procedure. The following steps walk you through adding an extended stored procedure to the system :
Copy the DLL that contains the extended stored procedure function to the server directory that contains the standard SQL Server DLLs. In a normal installation, ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
