Getting executed query details from MSSQL Log  
Author Message
bolfe





PostPosted: Fri Jul 15 11:25:02 CDT 2005 Top

SQL Server >> 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

SQL Server298  
 
 
AlejandroMesa





PostPosted: Fri Jul 15 11:25:02 CDT 2005 Top

SQL Server >> Getting executed query details from MSSQL Log Google for "dbcc log".

Understanding the SQL Server Transaction Log
http://www.windowsitlibrary.com/Content/77/21/1.html


AMB



> 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
 
 
Dejan





PostPosted: Fri Jul 15 11:28:42 CDT 2005 Top

SQL Server >> Getting executed query details from MSSQL Log > 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