|
Home > Archive > MS SQL Server Tools > March 2006 > how to sort object explorer items?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Robert Klemme 2006-03-24, 7:39 am |
| 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
| |
| Erland Sommarskog 2006-03-26, 8:26 pm |
| [Reposted, as posts from outside msnews.microsoft.com does not seem to make
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
|
|
|
|
|