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 <binary>.
- 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