Erratum:
The following piece if code is incomplete and I have placed the correct code below this:
declare @datestring varchar(12)
set @datestring = convert(varchar(12),dateadd(d,-3,getdate()),1)EXECUTE master.dbo.xp_delete_file
The correct code:
declare @datestring varchar(12)
set @datestring = convert(varchar(12),dateadd(d,-3,getdate()),1)
EXECUTE master.dbo.xp_delete_file 0, N'D:\Orisys\Backup\',N'bak', @datestring
Now Jeff, I'd like to thank you for your post. You know what? I knew you were going to be the first to comment because I remember from a while back something that you said about this same subject. You are right in a way because I also don't like arrogant people but I was not talking about them. I was talking about rookies/newbies that are really struggling to do it and in the workplace you don't get a lot of people that wants to help and they find pleasure in seeing someone suffering and eventually even get fired because they don't come right.
If you just know how I struggled in the beginning and how these forums helped me. I am willing to share my little bit of knowledge with anyone.
Hey remember! Jesus loves you.
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)