Custom Event ID

• Clea.Boe@creo.com

  SSC Enthusiast

  Points: 100

  More actions

  May 13, 2004 at 5:11 pm

  #85663

  Does anyone know how to write a custom Event ID to the Event log from SQL ?  I see xp_logevent and a couple of other similiar tools, but nothing thta allows me to write a custom and unique number to the event log.  Does anyone have any suggestions?

   

  Thanks in advance

  Clea

  Version: SQL Server 2000 (clustered) latest SP.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 14, 2004 at 7:23 am

  #506473

  You can use logevent.exe windows command, and execute it with xp_cmdshell from SQL.

  This program allows you to write any error with the id and shource that you need.