Results 1 to 4 of 4

Thread: [SQL server 2000]Read the logs .ldf

  1. 08-01-2006, 02:35 AM #1
    gatsu
    gatsu is offline Registered User
    Join Date
    Jun 2006
    Posts
    16

    [SQL server 2000]Read the logs .ldf

    Hi,
    I have an issue with an application, and i want to know what sql queries are done by this application. So i need to read the .ldf file, i have do some search on google, but i find nothing thant can be relevant.
    Reply With Quote Reply With Quote
  2. 08-01-2006, 08:31 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can trace that in profiler. To read log file, you need third party tools like Lumigent's Log Explorer. Keep in mind that select statement is not logged.
    Reply With Quote Reply With Quote
  3. 08-02-2006, 02:42 AM #3
    gatsu
    gatsu is offline Registered User
    Join Date
    Jun 2006
    Posts
    16
    Do you know if it exists some freeware to do this task ?
    Reply With Quote Reply With Quote
  4. 08-02-2006, 08:32 AM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I dont think so. Pro-actively you could run profiler and collect all info and store it in database including select statements.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules