Home Forums SQL Server 2005 Administering xp_delete_file not deleting files on share drive RE: xp_delete_file not deleting files on share drive
p_slevin
Grasshopper
Points: 12
More actions
February 27, 2015 at 3:40 am
#1780511
--Had problems with file delete,. which turned out to be the format of the date provided to the routine
--
declare@del_datechar(8)
set@del_date = convert(char(8),getdate()-2,112)
exec master.dbo.xp_delete_file 0,'c:\temp','bak',@del_date,1