February 27, 2003 at 12:56 pm
I'm required to remove xp_cmdshell from the master database for security reasons.
How do I do that.
A simple right click and delete did not do it.
February 27, 2003 at 1:19 pm
Exec sp_dropextendedproc 'Xp_name'
February 27, 2003 at 1:57 pm
Keep in mind that until you move the .DLL, someone can always re-add it. However, to be able to move the .DLL, you'll want to drop all stored procedures that refer to it, if possible.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 27, 2003 at 2:06 pm
You may want to think about setting the xp_cmdshell proxy account to someone or somthing without any privileges.
"Keep Your Stick On the Ice" ..Red Green
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply