Heh Grasshopper try this out .... :w00t:

let me know what you think

CREATE PROCEDURE dbo.spSetCopyFiles

@FilePath nvarchar(1000), -- eg: N'c:\logs\*.ldf'

@DestinationPath nvarchar(1000) -- eg: N'\etwork folder\'

AS

BEGIN

-- Developer:JL (South Africa) 05-March-2008

-- Schedule:Create a SQL...