Laboratory/MSSQL

xp_cmdshell 및 서버 구성 옵션

theking 2014. 6. 13. 11:45

 

 

-- 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

 

exec xp_cmdshell 'dir H:\'