Getting executed query details from MSSQL Log

Hi all,
plz consider this in urgent manner. Let me tell the situation. Someone
executed a query on a table around 5 hrs before. Is it possibel to get to
know that what query and from where and when it happened. Will the .ldf file
reader helps me in this ? ... plz iam waiting for the reply...
thanks in advance
Deepson Thomas
Google for "dbcc log".
Understanding the SQL Server Transaction Log
http://www.windowsitlibrary.com/Content/77/21/1.html
AMB
"Deepson Thomas" wrote:

> Hi all,
> plz consider this in urgent manner. Let me tell the situation. Someone
> executed a query on a table around 5 hrs before. Is it possibel to get to
> know that what query and from where and when it happened. Will the .ldf file
> reader helps me in this ? ... plz iam waiting for the reply...
> thanks in advance
> --
> Deepson Thomas
|||> plz consider this in urgent manner. Let me tell the situation. Someone
> executed a query on a table around 5 hrs before. Is it possibel to get to
> know that what query and from where and when it happened. Will the .ldf
> file
> reader helps me in this ? ... plz iam waiting for the reply...
If the log is not cleared, Lumigent Log Explorer or some other log reader
could help you (http://www.lumigent.com/products/le_sql.html).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com