how to sort object explorer items?

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

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 folde
rs
> in object explorer?  Or have we lost this GUI functionality by upgrading?

No.

robert

[Reposted, as posts from outside msnews.microsoft.com does not seem to m
ake
it in.]



frank (somewhere@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