Post reply

SQL trace entries to Windows App Log?

  • August 12, 2008 at 3:25 pm

    #211133

    I have a stored procedure set up to generate a trace and insert the information into a database. I'd like to know if that information can be sent instead/also to Windows Application Logs? Or even to a syslog server, or some such?

    I've been searching and searching, my google finger has gone limp, answers or pointers much appreciated!

    This is in SQL 2005 on Win2003 sp2.

    Thanks for your time,

    okaasama

  • August 12, 2008 at 9:58 pm

    #857151

    Not using any native tools, no. SQL Server is not set up in 2005 to write to those sources. However, using scripting, sure, once it's in the database. SQL 2008 can write Audit object hits to the app event log.

    K. Brian Kelley
    @kbriankelley

  • August 12, 2008 at 10:06 pm

    #857155

    Thanks for the response.

    Do you know if there are any scripts for doing so available?

    Thanks again,

    okaasama

  • August 12, 2008 at 10:23 pm

    #857163

    Not off-hand. Perl (Windows) has Win32::EventLog for writing to the event log and has Sys::Syslog to write to a syslog server.

    K. Brian Kelley
    @kbriankelley

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

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