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.