Microsoft KB Archive/308931

= FIX: Unicode Server Message Changes to &quot;????&quot; on Message Text When the Text is Saved by SEM =

Article ID: 308931

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3a

-



This article was previously published under Q308931



BUG #: 300082 (SHILOH_BUGS)



SYMPTOMS
If you create, edit or save a SQL Server message that is a unicode string through the SQL Server Enterprise Manager (SEM), the server message does not save as unicode. If you open the server message, the message text may change to &quot;????&quot;.

You can open the SQL Server message in SQL Server Enterprise Manager or Query Analyzer.



CAUSE
SQL Server Enterprise Manager does not supply the &quot;N&quot; prior to the unicode string during the insert operation.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around this problem create a server message by using the SQL Query Analyzer. Use the prefix character &quot;N&quot; explicitly to identify the string as unicode.

For example, you can use the following code to create a unicode server message with Query Analyzer: exec sp_addmessage 50001, 10, N' '



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.



Steps to Reproduce Behavior
You can use the following steps to reproduce the problem:
 * 1) Open the SQL Server Enterprise Manager.
 * 2) Right-click server, click All Tasks, and then click Manage SQL Server Messages.
 * 3) Click the Message tab, and then click New.
 * 4) In the Message Text text box, type the message text in Unicode.
 * 5) Click OK.
 * 6) On the Search tab. In the Error number text box type the newly created message number.
 * 7) Click Find. The newly created message text shows &quot;????&quot;.

Keywords: kbbug kbfix KB308931

-

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

© Microsoft Corporation. All rights reserved.