Software

Ask something
Discussion Locked

MS Query Analyzer

0 helpful
1 reply

by mchrien

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Easy one...when using Query Analyzer in SQL 7.0, I am constantly looking for information that is more than the default 256 characters that is shown, and I have to change it every time I open the application. Does anyone know if there is a registry value or default somewhere to change that to a default that's higher? Thanks in advance for your help!

1 reply

by maxwell edison

The Query Analyzer tool in SQL Server 7.0 is an ODBC app that can view up to 8000 bytes. To use it, select Current Connection Options in the Query menu. On the Advanced tab, increase the maximum characters per column from the default of 256.

Maxwell

This discussion is closed to new replies.