By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,410 Members | 1,626 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,410 IT Pros & Developers. It's quick & easy.

Monitoring SQL Server transactions

P: n/a
Hi,
I am new to SQL Server Administraion, and straight away there
occured a case in which some users modified the database and I have to
track 'em out something this :-

A table was modified on 17 - 03 -2006 and now I want to see what
queries occured on that day how can I do that! I have seen the
transaction log but it ain't helpful. Do help me out!

Mar 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
progrAMMAR (am****@gmail.com) writes:
I am new to SQL Server Administraion, and straight away there
occured a case in which some users modified the database and I have to
track 'em out something this :-

A table was modified on 17 - 03 -2006 and now I want to see what
queries occured on that day how can I do that! I have seen the
transaction log but it ain't helpful. Do help me out!


There is no function that comes with SQL Server that can help you. However,
there are 3rd party products that can read the transaction log and help
you to find the information you are looking for.

See http://www.lumigent.com and http://www.logpi.com for two of them.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.