INF: Cannot See Actual Data Values for Columns in Enterprise Manager (207396)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
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.
| Modification Type: | Major | Last Reviewed: | 10/17/2003 |
|---|
| Keywords: | kbinfo KB207396 |
|---|
|