Need VB/VB.NET Help

Question

Hai Folks

I Want a coding for Read the SQl Server Log Files

Now I am Using SQL Server 2000

For Example:
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................

Answer 1

Hi,

"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.

---
http://www.sqlserver2005.de
---

Answer 2

Thanks for reply...

I want to Read SQL Server Log file....

like SQL Profiler Trace Operation....

Please Reply me

Answer 3

The 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.)

Answer 4

Hi,

 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.

Thank u.........