SQL Server: Enable xp_cmdshell using sp_configure

The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.

---- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

—- To update the currently configured value for advanced options.

RECONFIGURE

GO

—- To enable the feature.

EXEC sp_configure 'xp_cmdshell', 1

GO

—- To update the currently configured value for this feature.

RECONFIGURE

GO

Now you can execute cmd script by using xm_cmdshell,

EXECUTE master..xp_cmdshell 'C:\AAT_PDF_Thumbnail_Generator\test.bat'

-- this can execute a bat file

-- try this command to create a new directory

exec xp_cmdshell 'MD "d:\test2"'

Tips: if you get errors like this:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 50
The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

This is bcs of the advanced options are turn off. you can use this statement to turn on the advanced options:

EXEC sp_configure 'show advanced options', 1 
GO 
RECONFIGURE WITH OVERRIDE