December 19, 2008 at 12:59 pm
How do I trace a particular database users/roles/database objects between a particular time period , say for the past 7 days . If today I would like to trace all the changes that happened to a particualr database object/role/user etc...How do i do it. And what are the prerequisites for doing this tracing.I mean what kind of tracing level should the database have and how do I check the tracing levels of the database .
Thanks
December 19, 2008 at 1:04 pm
Unless you are on SQL Server 2005/2008, or you were tracing the server already for the last week, you can't look back in time. On SQL Server 2005/2008 if you have Service Pack 2 installed, you can get limited information out of the default trace if the files have not rolled over yet. You can find out more on this in the following article:
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
On SQL 2000 if you weren't tracing already you won't find anything.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply