sys.sp_addmessage

Description

Stores a new user-defined error message in an instance of the SQL Server Database Engine. error messages can be an integer between 50,001 and 2,147,483,647. The combination of must be unique; an error is returned if the ID already exists for the The severity level of the error. For more information about severities, see Database Engine error severities

Syntax

sp_addmessage
[ [ @msgnum = ] msgnum ]
[ , [ @severity = ] severity ]
[ , [ @msgtext = ]
N
'msgtext'
]
[ , [ @lang = ]
N
'lang'
]
[ , [ @with_log = ] {
'true'
|
'false'
} ]
[ , [ @replace = ]
'replace'
]
[ ; ]