Viewing 11 posts - 1 through 11 (of 11 total)
I found the solution to this problem.
grant connect to guest
May 24, 2010 at 7:57 am
Never thought of that,
September 23, 2009 at 8:09 am
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.
September 23, 2009 at 7:55 am
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
January 22, 2009 at 9:01 am
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...
January 22, 2009 at 8:49 am
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...
November 25, 2008 at 9:33 am
i would be in your debt.
August 14, 2008 at 1:43 pm
Thanks, I have tried that but it is not very clean. I wonder if they have found a better solution in 2008.
August 14, 2008 at 10:14 am
That is what I thought.
August 13, 2008 at 5:39 am
sp_changedbowner 'sa' fixed the issue for me. 😀
April 18, 2008 at 6:01 am
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.
January 16, 2008 at 1:44 pm