Microsoft KB Archive/281680

= BUG: FORMATMESSAGE Works with the Same User-Defined Messages as RAISERROR =

Article ID: 281680

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;See Also&quot; section.

Keywords: kbbug kbpending KB281680

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.