Post reply

SQL 2005, RAISERROR with log will not write to event log

  • June 3, 2009 at 12:13 pm

    #155778

    Hi,

    I'm trying to make one of my SQL Servers write to the event log.

    I have a call

    RAISERROR(55058,19,1) with log

    The results section of the query analyser shows the error along with the text of the message for 55058, but nothing shows up in the system application event log. I does appear in the sql error log.

    My account is both a domain admin, and a SQL Server admistrator.

    Any ideas on this?

    Dave.

    Oh, the topic should say SQL 2000. But I can't change it.

  • June 3, 2009 at 1:44 pm

    #1004268

    What rights your account has on the local machine/domain is irrelevance. What the SQL Server Service account is may have some effect on this. Check what rights the SQL service account has.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 3, 2009 at 1:51 pm

    #1004273

    Hi Gail,

    It's running under the local system account. I think thats NT Authority\SYSTEM, which is in the administrators system group.

    Thanks,

    Dave

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply