InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:00:53 GMT20http://www.sqlservercentral.com/Forums/Topic738104-5-1.aspxTo 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 fileFri, 19 Jun 2009 05:47:17 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic738104-5-1.aspxthats right .You need not to find it in sp_configure .Its enabled by default but you need to be sysadmin.Fri, 19 Jun 2009 03:04:26 GMThi_abhay78http://www.sqlservercentral.com/Forums/Topic738104-5-1.aspxOnly 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 [url]http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx[/url]Fri, 19 Jun 2009 02:40:03 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic738104-5-1.aspxHi ExpertzCan 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. Fri, 19 Jun 2009 02:03:33 GMTEswin