Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

xp_cmdshell Expand / Collapse
Author
Message
Posted Friday, June 19, 2009 2:03 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,606, Visits: 1,039
Hi Expertz

Can anyone please tell me how to check whether "xp_cmdshell" in enabled in sql server 2000.

If disabled can you please tell me how to enable "xp_cmdshell" using Enterprise Manager or TSQL.




Tanx
Post #738104
Posted Friday, June 19, 2009 2:40 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 11:21 PM
Points: 646, Visits: 1,303
Only in 2005 its disabled by default for security reasons.
In 2000 you need to have sysadmin fixed role to use it.


Pls see the below link
http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx


-- Roshan Joe
*******************************************
There are two types of DBAs. Those who has skills and those who have permissions
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #738115
Posted Friday, June 19, 2009 3:04 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 13, 2014 12:27 PM
Points: 267, Visits: 386
thats right .You need not to find it in sp_configure .Its enabled by default but you need to be sysadmin.

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #738124
Posted Friday, June 19, 2009 5:47 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 5,886, Visits: 13,044
To enable
exec sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'

To disable
exec sp_dropextendedproc 'xp_cmdshell'

It should be disabled. people will often protect xp_cmdhell further by renaming the .dll file



---------------------------------------------------------------------

Post #738193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse