Microsoft KB Archive/207396

= INF: Cannot See Actual Data Values for Columns in Enterprise Manager =

Article ID: 207396

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 Q207396



SUMMARY
In the SQL Enterprise Manager, when you choose "Open Table" and click "Return all rows":
 * You cannot see actual data values for Binary, VarBinary, and Image datatype columns. The data values appear as.
 * You may or may not be able to see actual values for Text and nText columns depending on the length of Text data.



MORE INFORMATION
This behavior is correct and by design.

To work around this problem, use SELECT statements in the Query Analyzer to see actual data values.

Additional query words: datatype binary image

Keywords: kbinfo KB207396

-

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

© Microsoft Corporation. All rights reserved.