Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Sysmessages Table

    Hi All,

    I think I've posted this thread already but I can't find it, so I'll post it again. The sysmessages table in the master database has a column called dlevel and this column has the following values: 0, 1, 2, 4, 127, and 128. Does anybody know what these values mean?

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    they are numbers
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    According to BOL (after typing in "sysmessages" in the search box),
    dlevel is a smallint and is For internal use only.

    After doing work on customizing sysmessages, however, I would put forth that it is a error-severity-level-specific indicator of relative severity of the error. In other words, it is a way to sub-group or sub-rank the errors within a given severity.

    Check into the use of the STATE parameter in the RAISERROR section of BOL for some added insight into what makes me go out on this particular limb (well, BESIDES the motivation to do such things provided by my special extra "Hey Y'all, WATCH THIS" gene passed on to me by my family lineage).
    Last edited by TallCowboy0614; 08-01-07 at 18:09.
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •