Monitoring SQL Server transactions

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!

progrAMMAR (amrhsn@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx