Tobar (7/18/2013)
The functionality I would like is to be able to "right click" in the display panel and say "Lock display". When the session is closed, not just the display panel being hidden, the "lock" would clear. Anybody know how to communicate this $1M idea to MS?
The problem with this is that the results grid can change from one run to the next, so every time you run a query, you get a new grid and while you could theoretically save and restore the column widths between executions, it would be difficult and unreliable without some way to uniquely identify a result set.
You can get the grid to autosize a column (in an addin), but it will only take visible cells into consideration so I think your dream may be a long way off yet...
Edit: It turns out there is another private method that will resize taking all rows into account. That $1M may not be far away 😀
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);