I found the solution to this problem.

use msdb

grant connect to guest

go

Aaron

Never thought of that,

thanks

If you wanted to restart the agent service you need to be a local admin or use the service account as the login to ssms.

I ran a quick test and you are correct the permissions transfered correctly. I think I will go with this plan.

1. Run transfer user scripts

2. Detatch all databases

3. copy...

That would work, but I can forsee a problem, what about all the object permissions. I will have to run a test of attaching the databases to a new server...

That was my first idea. Then I was thinking that the Windows Event logs can be changed to save for 1 year if you make the maximum log size large...

i would be in your debt.

Aaron

Thanks, I have tried that but it is not very clean. I wonder if they have found a better solution in 2008.

Aaron

That is what I thought.

Thanks

sp_changedbowner 'sa' fixed the issue for me. 😀

Aaron

Thank you very much, that might be enough, then I can look at the secruity log in Windows to see who was logged in at the time.

Aaron