Tracing between a past time period

  • 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

  • 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