If SQL is running under a domain or admin account then yes, all you have to do is give that account permission to write in the folder.

Paul,

Thanks. That makes sense. I did some tests based on what you said and it seems to be working. Thank you very much.

Paul,

In your function

select @Sunday = 8 - @@datefirst

this gives me a 1

select @@datefirst

give me a 7

What is this supposed to do?

Thanks for your help

Thank you Paul, I will try this function and let you know how it worked out.

Tarique