SQL extended stored procedure installation and Uninstall

Assume that the DLL file that is already doing the extended stored procedure is Dbxp_skate.dll

--First copy the DLL file (Dbxp_skate.dll) to the Binn directory where the SQL program resides, such as C:\Program Files\Microsoft SQL Server\mssql\binn

--Installing extended stored procedures
EXEC master.. Sp_addextendedproc ' xp_dbevent ', ' Dbxp_skate.dll '

--calling an extended stored procedure
EXEC master.. Xp_dbevent 1, ' A ', ' B '

--executes sp_helpextendedproc to display the DLL files currently loaded by SQL Server.
exec sp_helpextendedproc @funcname = ' xp_dbevent '-view DLL to which xp_dbevent belongs
EXEC sp_helpextendedproc-View DLL files loaded by SQL Server

--Uninstalling extended stored procedures
EXEC master.. Sp_dropextendedproc ' Xp_dbevent '

--Unload the specified extended stored procedure dynamic link library (dbxp_skate.dll) from memory
DBCC DBXP_SKATE (FREE)