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', 'xp_hello.dll'

  

This is in a sample only available if you select Dev Tools During setup.

See Also

sp_dropextendedproc

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.