June 19, 2009 at 2:03 am
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 😀
June 19, 2009 at 2:40 am
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
June 19, 2009 at 3:04 am
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)
June 19, 2009 at 5:47 am
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
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply