How to log events in the Event Log using SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » How to log events in the Event Log using SQL...

How to log events in the Event Log using SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Sriram-288748

Posted Tuesday, September 29, 2009 12:23 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

How to log events in the event log using sql server, i am trying to do something like, if there is a condition and its success/failure then a log should go into the event log

Sriram

Post #794928

ps.

Posted Tuesday, September 29, 2009 1:00 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

use RaiseError or xp_logevent sp.
refer : http://tejasnshah.wordpress.com/2009/04/02/sql-sever-how-to-make-an-entry-in-event-viewer-using-sql-server/
http://www.codeproject.com/KB/database/Raiserror.aspx

Pradeep Singh

Post #794938

Sriram-288748

Posted Tuesday, September 29, 2009 4:05 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

Is there any way to get the work done without needing the permission off dbo on master database. or without having a sysadmin role....

thanks.

Sriram

Post #794995

« Prev Topic | Next Topic »

Permissions