• subscribe
May 18, 2005 12:00 AM

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

SQL Server Pro
InstantDoc ID #46219

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.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...