Post reply

Reading the event log from isnide SQL Server

  • September 14, 2004 at 8:29 am

    #85375

    Is there any possibility to read the event log from insdie SQL Server 2000? I know there is an undocumented extended stored procedure xp_eventlog in the master database, but it seems that is not working.

    Gabriela

  • September 14, 2004 at 8:51 am

    #522979

    Per http://www.winnetmag.com/SQLServer/Article/ArticleID/23160/23160.html the xp_eventlog proc doesn't work in SQL Server 2000. If you really wanted to you could use xp_cmdshell to run some OS program that would strip out the desired event log entries and write them to a SQL Server table. Since I'm guessing you're not going to find a freeware/shareware or commercial program to do that for you it would need to be a custom built program.

  • September 14, 2004 at 8:59 am

    #522981

    The resource kit has a utility called logparser. You can directly dump data into sql tables using this utility or process the data as you need. You can run this using xp_cmdshell as Aaron suggested.

  • September 14, 2004 at 2:32 pm

    #523062

    Thanks. LogParser works fine.

    Gabriela

  • January 5, 2005 at 10:54 am

    #536035

    I contributed a nifty stored procedure that uses LogParser to import EventLog data -- take a look.  Just do a search for LogParser and the script will be in the results.

    Mark

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply