Thanks John,

I've just implemented option 3 using a script I borrowed from sqlservercentral. It works fine as a temporary solution.

When I find time I'll  look into the other options you mentioned.

Wayne