raiserror with log

• elw1019

  SSC Journeyman

  Points: 90

  More actions

  January 21, 2005 at 8:35 am

  #60915

  Receiving following error when using raiserror with severity level 20-25.

   

  RAISERROR ('Exiting script', 25, 1, 'WITH LOG', 'NOWAIT')

  Server: Msg 2754, Level 16, State 1, Line 1

  Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.

  The login I'm using is a member of the sysadmin role.  Any suggestions?

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  January 24, 2005 at 8:23 am

  #538760

  Try this syntax instead:

  RAISERROR ('Exiting script', 25, 1) WITH LOG

   

  /Kenneth