Thanks Lynn and thatok for you help.

I've opted to just replace USER_NAME() with SUSER_NAME() and everything is now working the way I want it to.

Yesterday's frustration was brought to...

Much thanks to everyone for their input. I am confident that you have given me the information I need to dig into this problem and figure out how to...

Thanks for your reply, Lynn.

I'm with you as far as archiving based upon time rather than table size. Makes sense and sounds easier. Plus, I think...

Thanks for your reply RBarryYoung. You have brought up some good questions.

The thought is (or at least what my boss is telling me) that if we allow...