|
Home > Archive > Microsoft SQL Server forum > March 2006 > Monitoring SQL Server transactions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Monitoring SQL Server transactions
|
|
| progrAMMAR 2006-03-22, 9:28 am |
| 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!
| |
| Erland Sommarskog 2006-03-22, 8:33 pm |
| 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
|
|
|
|
|