Hello All

Many thanks for your responses.  Unfortunately my issues are specific to SQL 2000 and not Yukon.  I opened the thread in the wrong forum.

Once again thank you for your...

Many thanks for all your responses.  This started of as a simple task to try and make life easier - when in fact I think I am making things much...

Once again many thanks for your response Yelena.

I try and keep my SQL Server security model simple and as secure as possible.   I do not use SQL Server authentication only...

Hi Yelena

Thanks for taking the time out to reply.

I have about 60 databases that are included in the Log shipping scenario.

However my thinking was to try and automate this as much...