网络拷贝数据

USE master
--映射盘符Z
exec master..xp_cmdshell 'net use z: \\192.168.0.117\c$ "密码" /user:192.168.0.117\administrator'
--映射后拷贝
EXEC xp_cmdshell 'copy e:\0724.bak z:\',NO_OUTPUT
--映射后删除
exec master..xp_cmdshell 'net use z: /delete'

posted @ 2006-07-25 18:13  azhai  阅读(396)  评论(0编辑  收藏  举报