-
[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.
-
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.
-
Do you know if it exists some freeware to do this task ?
-
I dont think so. Pro-actively you could run profiler and collect all info and store it in database including select statements.
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
|
|