Tracing between a past time period

Question

Tracing between a past time period

mtz676

SSCrazy Eights

Points: 9217
More actions
December 19, 2008 at 12:59 pm

#155040

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

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.