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

• Microsoft SQL Server version 7.0

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 : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbinfo