Re: copy a file with xp_cmdshell
From: reddy (reddy_at_discussions.microsoft.com)
Date: 06/29/04
- Next message: Kevin3NF: "Re: Recruitment of dba's question"
- Previous message: Citizen: "Re: 1 server 2 SQL apps"
- Maybe in reply to: reddy: "copy a file with xp_cmdshell"
- Next in thread: Tim Greenwood: "Re: copy a file with xp_cmdshell"
- Reply: Tim Greenwood: "Re: copy a file with xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 07:25:01 -0700
hi friends,
i tried all your suggestions.but not working for me.
i am getting the follwing errors
if i use copy
EXEC master..xp_cmdshell 'xcopy \\e-060\c\updates.txt d\upd.txt'
Invalid drive specification
if i use xcopy
EXEC master..xp_cmdshell 'xcopy \\e-060\c\updates.txt d\upd.txt'
Logon failure: unknown user name or bad password.
plase suggest if any otherways are there to copy the files
thanks®ards
reddy
- Next message: Kevin3NF: "Re: Recruitment of dba's question"
- Previous message: Citizen: "Re: 1 server 2 SQL apps"
- Maybe in reply to: reddy: "copy a file with xp_cmdshell"
- Next in thread: Tim Greenwood: "Re: copy a file with xp_cmdshell"
- Reply: Tim Greenwood: "Re: copy a file with xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]