Posted by Erland Sommarskog on 03/23/06 00:57

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How do I change the default collation string of an installation
• Prev in forum: Re: Update n rows
• Thread view: Re: Monitoring SQL Server transactions

[Reply to this message]