Declare @DOSCommandLine varchar(500)

set @DOSCommandLine = 'Copy ' + @DirectoryString + @FileName1 + ' + ' +
@DirectoryString + @FileName2 + ' ' + @DirectoryString + @ResultFile + ' '


EXEC master..xp_cmdshell @DOSCommandLine

Hope this works

-----Original Message-----
From: Sunil Dhyani
[mailto:mssqldba-ezmlmshield-x81438738.[Email address protected]
Sent: 28 February 2007 02:11 PM
To: LazyDBA Discussion
Subject: How to copy file using stored procedure?

How to copy file using stored procedure?

I am trying through sp_qamethod, but doesn't know the whole syntax

Pls help

Rgds,
Sunil


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page