October 25, 2011 at 8:14 am
A long time ago, I found a blog post from someone detailing for SQL 2005 how to modify the system proc that enumerates objects in the Object Explorer / Summary pane on SSMS. It was basically "Add this ORDER BY clause to the proc". Now we've upgraded to SQL 2008 and when I try to sort, it throws the folders in the mix instead of leaving them on top.
The issue is, I want to be able to change sorting by Date, Schema, or Name, depending on what I'm looking for, but I want to keep the folders (System Stored Procedures, for instance) up at the top. I know it's a simple fix, but I cannot find the proc that enumerates this stuff.
Any thoughts on where this post is hiding or what proc comes up with the Summary pane / Object Explorer Details list? I can't find it by searching the system procs. I've tried. I'm probably looking for the wrong name anyway.
October 26, 2011 at 10:08 am
Have you tried profiling your ssms session to find the proc?
October 26, 2011 at 10:21 am
I'm not sure if this helps, but have you tried using the Filtering functionality in SSMS to find what you are looking for? It isn't the same, but it gets you specifically what you are looking for and is a CONTAINS not an exact match.
In object explorer details you can sort by name, schema, date, path.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 7, 2011 at 6:10 am
Sorry it took me so long to respond. I've been busy.
I appreciate the answers, but I'm not sure you understand what I'm looking for. I want to fiddle with the SSMS Object Explorer "settings".
Still, I'll check profiler and see if it tells me what procs are being accessed when I open up Object Explorer. I doubt it will, though, considering that I can't find the information in the regular sys.objects / information_schema views.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply