Registers the name of a new extended stored procedure to Microsoft SQL Server.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead.
Applies to: SQL Server (SQL Server 2008 through current version).
After an extended stored procedure is created, it must be added to SQL Server by using sp_addextendedproc. For more information, see Adding an Extended Stored Procedure to SQL Server.
This procedure can be run only in the master database. To execute an extended stored procedure from a database other than master, qualify the name of the extended stored procedure with master.
sp_addextendedproc adds entries to the sys.objects catalog view, registering the name of the new extended stored procedure with SQL Server. It also adds an entry in the sys.extended_procedures catalog view.
Existing DLLs that were not registered with a complete path will not work after upgrading to SQL Server 2014. To correct the problem, use sp_dropextendedproc to unregister the DLL, and then reregister it with sp_addextendedproc, specifying the complete path.
The following example adds the xp_hello extended stored procedure.
USE master; GO EXEC sp_addextendedproc xp_hello, 'c:\xp_hello.dll';