How to order project solution content in SQL Server Management Studio

Question

In SQL Server Management Studio (SSMS) running against SQL Server 2005, I have a solution which contains a number of views.

These views are not sorted alphabetically.

Can anyone provide either an explanation of why, or a solution to order them alphabetically ?

Answer 1

I just came across this forum post. It doesn't get any simpler.

Just edit the ssmssqlproj file.

The file for my project (SQL Main) is located in "My Documents\SQL Server Management Studio\Projects\SQL Main\SQL Main\SQL Main.ssmssqlproj". Its just an xml file. Change the following line

<LogicalFolder Name="Queries" Type="0" Sorted="true">

to

<LogicalFolder Name="Queries" Type="0" Sorted="false">

It will revert back to true so you need to repeat this if you make changes. THere is probably a better way Smile