Removing an Extended Stored Procedure from SQL Server
From Extended Stored Procedure Programming
Removing an Extended Stored Procedure from SQL Server
To drop each extended stored procedure function in an extended stored procedure DLL, a Microsoft® SQL Server™ system administrator must run the sp_dropextendedproc system stored procedure, specifying the name of the function and the name of the DLL in which that function resides. For example, this command removes the function xp_hello, located in Xp_hello.dll, from SQL Server:
sp_dropextendedproc 'xp_hello'
This is in a sample only available if you select Dev Tools during setup.