After you create your own extended stored procedure, you should register
the name of a new extended stored procedure to SQL Server by using the
sp_addextendedproc system stored procedure.
Read about the sp_addextendedproc system stored procedure in SQL Server Books Online.