Copying Event Log Data from NT to SQL Server

[tlaksh]

Does anyone know how to automatically pick up data from NT Event Log into a MS SQL Server 7.0 Table. I have tried to save it to text file and then using the DTS utility to upload it into the table. This works fine but I need to do it for a many servers on a regular basis and hence the need to automate.

Also can anyone tell me the name of the file from where Event Viewer displays data in Windows Nt 4.0.

Thanks

Lakshmi.

 

[ColinM]

You could maybe adjust this code

http://www.alphasierrapapa.com/iisdev/Components/EventLog/