Verbose Application Logging?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Co Co Net - 21 Jul 2008 17:18 GMT

How can I make all services and jobs and etc verbosely log to the
Application Log on the server? Replication stuff goes to a table, jobs
go to tables, etc. I would like to centrally capture them all so my
monitoring tool can just go to a single place.

Thanks.

Reply to this Message

Linchi Shea - 21 Jul 2008 19:11 GMT

If the tools are not writing to the app eventlog and can't be configured to
do so, you would have to trap the errors yourself, and write them to the app
eventlog yourself.

Linchi

> How can I make all services and jobs and etc verbosely log to the
> Application Log on the server? Replication stuff goes to a table, jobs
> go to tables, etc. I would like to centrally capture them all so my
> monitoring tool can just go to a single place.
>
> Thanks.

Reply to this Message

Co Co Net - 31 Jul 2008 20:10 GMT

Some things like Replication are logged to a table. I would like the
same thing to be written to the Event Log. Isn't there a way to make
SQL Server operations go to the Application Event Log?

>If the tools are not writing to the app eventlog and can't be configured to
>do so, you would have to trap the errors yourself, and write them to the app
[quoted text clipped - 8 lines]
>>
>> Thanks.

Reply to this Message

Ekrem Önsoy - 31 Jul 2008 20:59 GMT

Only, Severity Level of over 19 messages are loged to the Application Log by
default.

You can also use WITH LOG when calling RAISERROR in your database
applications to save the errors in the Application Log.

Signature

Ekrem Önsoy

> Some things like Replication are logged to a table. I would like the
> same thing to be written to the Event Log. Isn't there a way to make
[quoted text clipped - 14 lines]
>>>
>>> Thanks.

Reply to this Message