Microsoft KB Archive/273593

= BUG: SEM Help Displays Incorrect Size Information for Unicode Columns =

Article ID: 273593

Article Last Modified on 10/17/2003

-

APPLIES TO


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

-



This article was previously published under Q273593



BUG #: 58384 (SQLBUG_70)

BUG #: 236165 (SHILOH)



SYMPTOMS
When you display the properties of a table that contain UNICODE columns in the SQL Server Enterprise Manager (SEM), the Size(Precision,Scale) column lists the number of characters that can be stored in that column, not the column size in bytes as the Help states.



WORKAROUND
Run sp_help 'tablename' to return the correct column size in bytes.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB273593

-

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

© Microsoft Corporation. All rights reserved.