Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

Enabling xp_cmdshell in SQL Server 2005

By default, xp_cmdshell is disabled in SQL Server 2005 for security reasons.  I am currently using xp_cmdshell in my backup stored procedure to delete files, so I must enable xp_cmdshell on my SQL Server 2005 instances.  There are two ways to enable this option: Surface Area Configuration tool or sp_configure.  Enabling this option via Surface Area Configuration tool is rather straight forward.  Here is the script to enable xp_cmdshell in SQL Server 2005 via sp_configure:

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Print | posted on Thursday, September 14, 2006 4:51 PM | Filed Under [ SQL Server - Database Administration ]

Feedback

Gravatar

# xp_cmdshell, appunti di utilizzo

Questo non è un semplice tip, infatti sottintende parecchio di più. Sto parlando di come impedire ad...
10/20/2006 11:34 AM | Maurizio Tammacco's blog
Gravatar

# re: Enabling xp_cmdshell in SQL Server 2005

' UNION SELECT * FROM sysobjects --
11/23/2006 3:22 AM |
Gravatar

# re: Enabling xp_cmdshell in SQL Server 2005

good for me, thanks so much! friend.
11/26/2006 7:29 PM | joey
Gravatar

# re: Enabling xp_cmdshell in SQL Server 2005

thanks a lot
12/8/2006 1:28 AM | Roko
Gravatar

# Enabling xp_cmdshell in SQL Server 2005

Found this helpful little script from Tara Kizer : EXEC master . dbo . sp_configure 'show advanced options'
4/21/2007 7:24 PM | Stabilized Chaos
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET