Double-Click on a Column to Show a Grid's Full Data Length

You can double-click on the end of the column marker and the column will auto-expand to show the full data.

Brian Moran

May 17, 2005

1 Min Read
ITPro Today logo in a gray background | ITPro Today

Have you ever been frustrated when using Query Analyzer's grid view to look at long strings of data? It can be frustrating to get the entire string to display. You can double-click on the end of the column marker and the column will auto-expand to show the full data. This trick works for most SQL Server tools and many other tools that provide a grid. It will help you see long file names when you're looking at database properties and long values when looking at large traces in SQL Server Profiler. This feature has been around since the release of SQL Server 2000, and I'm sure that many people are aware of it. But I just recently figured this out, and I'm probably not the only one who didn't know.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like