July 19, 2006 at 12:22 pm
SQL Server 2000 SP4
I have a server that has a role. The local group that populated that role was inadvertently removed by a DBA or Admin within the last few weeks. Is this information stored anywhere in a logfile? I looked through the error logs to no avail (obviously).
If the answer to my question is no, is there a way to set this up without third-party software?
July 20, 2006 at 8:05 am
John, I am not sure about where to find it, but I am actually in the process of writing a group of sp's to look at all server and database roles and the logins associated with each etc. Based on that I am going to create audits to see when any new logins are added as well as generating a script that will run weekly to backup the logins associated with those roles. I was concerned with running into very issue you did. I would be happy to share those with you when I am done if you are interested.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply