Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copying files across the network using TSQL

Status
Not open for further replies.
eja2000

eja2000

Programmer
Nov 30, 2003
209
NG
how can i copy files across the network from one PC to another using TSQL?
Thanks
 
Sort by date Sort by votes
use xp_CMDShell to run copy. For Example:
Code: 
xp_CMDShell 'copy c:\autoexec.bat \\server2\c$\autoexec.bat'

Denny

--Anything is possible. All it takes is a little research. (Me)

[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
578
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
660
Mike Lewis
Mike Lewis
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
561
RobertPhillips
RobertPhillips
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
384
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top