BUG: FORMATMESSAGE Works with the Same User-Defined Messages as RAISERROR (281680)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q281680
BUG #: 101102 (SQLBUG_70)
BUG #: 351525 (SHILOH)

SYMPTOMS

The FORMATMESSAGE system function only works with error messages between the values of 13000 and 2147483647.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Microsoft has confirmed this to be a problem in SQL Server 2000.

MORE INFORMATION

SQL Server Books Online implies this limitation in the following ways:
  • It states that the functionality of FORMATMESSAGE resembles that of the RAISERROR statement.
  • It uses a hypothetical error message 50001 in the example rather than an existing standard error message.
  • It refers to sp_addmessage in the "See Also" section.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbbug kbpending KB281680
©2003 Microsoft Corporation. All rights reserved.