xp_cmdshell

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » xp_cmdshell

xp_cmdshell

Rate Topic

Display Mode

Topic Options

Author

Message

Eswin

Posted Friday, June 19, 2009 2:03 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:19 AM
Points: 1,593, Visits: 1,025

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 BigGrin

Post #738104

joeroshan

Posted Friday, June 19, 2009 2:40 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573, Visits: 1,169

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
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups

Post #738115

hi_abhay78

Posted Friday, June 19, 2009 3:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267, Visits: 385

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

george sibbald

Posted Friday, June 19, 2009 5:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:32 PM
Points: 5,270, Visits: 11,213

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 »

Permissions