Sp_configure를 사용하여 xp_cmdshell 활성화 시키기

 

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

 

 

xp_cmdshell 'copy c:\abc.hwp d:\abc.hwp'

실행결과 :