• 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)