Thursday, October 19, 2006 1:54 PMHai Folks
I Want a coding for Read the SQl Server Log Files
Now I am Using SQL Server 2000
Test is a database Name...
Test_Data.MDF is a Data File Name
Test_Log.LDF is a Log File Name
Now I Create a Table Name Check with Single Field
Now I want to check this Details like I run this VB Coding then Its tell me The Last Transaction of the Test database is Create a Table Name is Check
I hope You can Understand My Request...
In exact Wors I want JobHistory of Some Table...
If its Possible VB.NET than Please give me a Sample Code
Please This is very Very Urgent................
Thursday, October 19, 2006 6:09 PMModeratorHi,
"Read the SQl Server Log Files"
-Do you want to read the logfile or some table data ?
I really did not understand you explanation. Do you want to track the created tables ? There is no log for that unless you use SQL 2k5 and DDL trigger or read the log file with a third party log viewer.
(Creating a trigger on the system tables is not an option)
HTH, Jens K. Suessmeyer.
Thursday, October 19, 2006 6:36 PMThanks for reply...
I want to Read SQL Server Log file....
like SQL Profiler Trace Operation....
Please Reply me
Thursday, October 19, 2006 6:46 PMThe SQL Server log file will not give you specific actions taken in the database. The transaction log is different, and it does have a record of every change made in the database, but your best bet there is to purchase a third party application that parses that log. (Something along the lines of Log P.I. is probably what you're looking for.)
Friday, June 22, 2012 11:40 AM
Even i would like to know if there is any code to read Backup files.
Cos the EventLog function which is available in .NET is only for reading the local machine log.
Any idea for the Logs which has different columns other than local Log and any other class other than the the diagnostics.