July 1, 2003 at 9:12 am
I wanted to find out what people were using to find out what user modified a certain table 2 days ago (for example). Sql profiler looks like it's "turned on" and you run it for a certain time but unless it's turned on all the time I will not know when a user deleted something several days ago.
Thanks,
Tracy
July 1, 2003 at 10:01 am
Chances are less likely to figure it out what exactly the users running against the tables, if you don't have the Profiler turned on. What you can do is to have the profiler to insert the data (userid, Action and the Station they are running,...) into a table and you can make reports out of it. Depends on data volumes you need to recycle your monitoring Database every week or two. If you are running SQL7.0 here is a statement you can use
Exec master..xp_sqltrace Trace, @EventFilter = 115, @Fulltext = 1
Shas3
July 1, 2003 at 10:35 am
Check out this article:
http://www.sqlservercentral.com/columnists/hji/trace.asp
You can setup a server-side trace without using Profiler that will be turned on all the time. As Shas3 wrote, you can put the trace data into a table and write some reports to look at the history.
July 3, 2003 at 3:38 pm
I've used Log Explorer from Lumigent (www.lumigent.com) for several years the price is reasonable and it accomplishes just this type of thing very easily by reading the SQL Server transaction log.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply