Registering an Extended Stored Procedure in SQL Server

This is to supplement the sp_addextendedproc documentation in Books Online.

USE master
EXEC sp_addextendedproc 'xp_yourExtendedFunction', 'xp_ExtendedDLL.dll'

For this to work you need to copy the xp_ExtendedDLL.dll to the BINN directory of the SQL Server.

for default installation of
SQL Server 2000
C:\Program Files\Microsoft SQL Server\MSSQL\Binn

SQL Server 2005
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

Happy programming