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
SOURCE | LINK | LANGUAGE | ENGLISH |
Whats up! I just want to give an enormous thumbs up for the good info you’ve got right here on this post. I can be coming again to your weblog for extra soon.