| Author |
Getting executed query details from MSSQL Log
|
|
| Deepson Thomas 2005-07-15, 11:23 am |
| 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
| |
| Alejandro Mesa 2005-07-15, 11:23 am |
| 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
| |
| Dejan Sarka 2005-07-15, 11:23 am |
| > 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
|
|
|
|