How to log events in the Event Log using SQL Server

• Sriram-288748

  SSCrazy

  Points: 2874

  More actions

  September 29, 2009 at 12:23 am

  #98008

  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

• ps.

  One Orange Chip

  Points: 29423

  More actions

  September 29, 2009 at 1:00 am

  #1059326

  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

• Sriram-288748

  SSCrazy

  Points: 2874

  More actions

  September 29, 2009 at 4:05 am

  #1059363

  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