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

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.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.