SS2005: Change query order in SQL Management Studio Solution Explorer

9 Feb 2007 3:30 PM

vimas

Hello,

Is there an easy way to change query order to alphabetic in Solution
Explorer in Microsoft SQL Server Management Studio?
I have a lot of SP in the list and they all are in order they were added to
project. But I need alphabetical order.
I can see file .ssmssqlproj that list all queries in XML format and that I
probably can change, but I want order to be automatical.
I know this is small thing, but it drives me nuts.

Thanks

9 Feb 2007 6:06 PM

Tibor Karaszi

http://sqldbatips.com/showarticle.asp?ID=78

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quote

"vimas" <nob***@nowhere.com> wrote in message news:uVvqE9FTHHA.1036@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> Is there an easy way to change query order to alphabetic in Solution
> Explorer in Microsoft SQL Server Management Studio?
> I have a lot of SP in the list and they all are in order they were added to
> project. But I need alphabetical order.
> I can see file .ssmssqlproj that list all queries in XML format and that I
> probably can change, but I want order to be automatical.
> I know this is small thing, but it drives me nuts.
>
> Thanks
>
>

12 Feb 2007 6:30 PM

Paul A. Mestemaker II [MSFT]

Yeah, this is very basic functionality that is very annoying. We fixed in
SQL Server 2005 Service Pack 2.

For information about SP2, please visit my blog:
http://blogs.msdn.com/sqlrem/archive/2007/01/12/SP2-and-BPA-FAQ.aspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Show quote

"vimas" <nob***@nowhere.com> wrote in message
news:uVvqE9FTHHA.1036@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> Is there an easy way to change query order to alphabetic in Solution
> Explorer in Microsoft SQL Server Management Studio?
> I have a lot of SP in the list and they all are in order they were added
> to project. But I need alphabetical order.
> I can see file .ssmssqlproj that list all queries in XML format and that I
> probably can change, but I want order to be automatical.
> I know this is small thing, but it drives me nuts.
>
> Thanks
>
>