Is it possible to log a message in system event log through SP?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi All

This code adds the message in "Sys.messages" of sql server.
sp_addmessage 50006 , 18 , 'error occurred while updating the variable value',
@with_log = 'true',
@Replace='replace'

But i want the same message to be logged in system event log also.But this code doesnot add the message to event log.Can anyone tell me what is the problem with the code?

Posted 2-Feb-11 23:12pm

froxy

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2011-02-02T23:27:00

Solution 1

If you want to write to the Windows Event log, use xp_logEvent

http://msdn.microsoft.com/en-us/library/aa260695%28SQL.80%29.aspx[^]

Posted 2-Feb-11 23:27pm

Dylan Morley

Comments

froxy 3-Feb-11 5:41am

I executed the following code.But the message was not available in Event viewer.

USE master
EXEC xp_logevent 60006,'fsdfsdf', informational

Where can i look for the message?

Dylan Morley 3-Feb-11 5:54am

It will show under the Application log, with a source of MSSQLSERVER

Can you confirm you have the correct permissions?

"Requires membership in the db_owner fixed database role in the master database, or membership in the sysadmin fixed server role."

Is it possible to log a message in system event log through SP?

1 solution

Solution 1

Add your solution here

Preview 0

Is it possible to log a message in system event log through SP?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us