Thursday, April 4, 2013

Enabling MS SQL Server to run Command Line Applications

For Microsoft SQL Server to be able to run windows command line applications the following query must be run.

USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO