--启用xp_cmdshell
USE master
EXEC sp_configure'show advanced options',1
RECONFIGURE
EXEC sp_configure'xp_cmdshell', 1
RECONFIGURE
declare @cmd varchar (1024)
--SET @Cmd=('master.dbo.xp_cmdshell '+'''xcopy D:\3\*.*'+'\\'+@machine+@path+'\ '+' /y/s'+'''')
--拷贝目录及其以下的文件master.dbo.xp_cmdshell 'xcopyD:\3\*.* \\192.168.200.175\208bf\ /y/s'
SET @Cmd=('xp_cmdshell '+'''xcopy D:\a\*.* '+ 'D:'+'\208bf'+'\ '+' /y/s'+'''')
EXEC (@Cmd)
--关闭xp_cmdshell
USE master
EXEC sp_configure'xp_cmdshell', 0
RECONFIGURE
EXEC sp_configure 'showadvanced options', 0
RECONFIGURE