Home All Groups Group Topic Archive Search About

how to sort object explorer items?

Author
23 Mar 2006 11:14 PM
frank
Sqlserver 2005 Management Studio 'Object Explorer' lists servers, similar to
Sqlserver 2000 Enterprise Manager.  However, I can't find any way to sort
object explorer's items?  Also Enterprise Manager let you create folders to
organize your registered servers; I can't find a way to do this in object
explorer either.

Is it possible to sort the connections and organize them by creating folders
in object explorer?  Or have we lost this GUI functionality by upgrading?

-Frank Brown

Author
24 Mar 2006 10:33 AM
Robert Klemme
frank wrote:
> Sqlserver 2005 Management Studio 'Object Explorer' lists servers, similar to
> Sqlserver 2000 Enterprise Manager.  However, I can't find any way to sort
> object explorer's items?

Apparently they are sorted in insertion order.  I couldn't find a way to
change that yet.

> Also Enterprise Manager let you create folders to
> organize your registered servers; I can't find a way to do this in object
> explorer either.

Right mouse click new -> server group.

> Is it possible to sort the connections and organize them by creating folders
> in object explorer?  Or have we lost this GUI functionality by upgrading?

No.

    robert
Author
26 Mar 2006 8:23 PM
Erland Sommarskog
[Reposted, as posts from outside msnews.microsoft.com does not seem to make
it in.]



frank (somewh***@rainbow.net) writes:
> Sqlserver 2005 Management Studio 'Object Explorer' lists servers,
> similar to Sqlserver 2000 Enterprise Manager.  However, I can't find any
> way to sort object explorer's items? 

How would you sort them if you could?

During the beta, they had some options to view by schema, but that was
dropped.

> Also Enterprise Manager let you create folders to organize your
> registered servers; I can't find a way to do this in object explorer
> either.

Since Object Explorer lists only servers that you are currently connected
to, it would not really make sense. At least, those folders could not be
stored anywhere.

On the other hand, you can organise Registered Servers in groups just
like you could in Enterprise Manager.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seBooks Online for SQL
Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button