errors in sql server

  • If an error occurs in sql server how to identify that error is application error or

    database error?

  • If the error number is 13,000 or greater and the severity is 18 or lower then it could have been either the database engine or a user. Users cannot explicitly raise errors with a number under 13,000 or with a severity of 19 or higher.

    Other than that there is no real way to tell, although users do not typically raise errors with an error number less than 50,000:

    SELECT *

    FROM sys.messages

    WHERE message_id >= 13000

    AND language_id = 1033

    ORDER BY message_id

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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