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.
May 17, 2005
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.
About the Author
You May Also Like