Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Post Unanswered: about messges in microsoft sql express

    Msg 156, Level 15, State 1, Line 6
    Incorrect syntax near the keyword 'contains'.
    Msg 102, Level 15, State 1, Line 8
    Incorrect syntax near ')'.

    i am getting error messages like this.
    I want to know what this message really
    mean i.e list of messages corresponding to numbers........

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The SQL engine uses only the error numbers internally. Those are what the engine know about, and are how it complains about "bad code" that it receives from the SQL client. The error message displayed below the Msg line contains a description of the error in the current locale (in this case, essentially a human language like English, Spanish, French, etc).

    The process of getting the text description is simply a table lookup, there's no "magic" associated with it. The table of error messages changes constantly, usually with every service pack.


  3. #3
    Join Date
    May 2004
    they are stored in sysmessages:

    select * from sysmessages where error in (102,156)

Posting Permissions

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