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', 1GO—- To update the currently configured value for advanced options.RECONFIGUREGO—- To enable the feature.EXEC sp_configure 'xp_cmdshell', 1GO—- To update the currently configured value for this feature.RECONFIGUREGO

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