Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2000
 Removing an Extended Stored Procedu...

  Switch on low bandwidth view
Extended Stored Procedure Programming (SQL Server 2000)
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.

See Also

sp_dropextendedproc

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker