Hi Brian.

IS_MEMBER() is like magic for my eyes!!

THEY will not have more excuse....

I'll try do someone to reprogram something to use it and cross my fingers to have the program...

Thank you, I'll try and tell you somethig about.

Hi Brian. thank you for your reply.

We have done that you suggest. The active directory groups are members of the database roles, but we only have the user credentials. How...

😉 I DID IT!!!

Thank you all for your feedback.

The final solution is a little tricky but it works.

Opened the SSIS console and looks a good toy, but I have had...

Thank you for the suggestion GSquared.:)

I´ll try the independent job an let you know if it works.

As for the SSIS package, is all new for me (never needed to program!!!)....

Check bottlenecks when writing. Try to avoid two servers backing up just at the same time.