In SQL Server Management Studio, when you added more items (such as queries) in your project, they are always in the order of latest to oldest from up to down, but not sorted alphabetically. It can be problematic if you have do dozens, or more items, it is hard to find the one your need. Here is a screenshot:
The workaround to let them sorted by alphabet is to change the “Sorted” property from “true” to “false”. Here are steps in detail:
- Save and close your solution from Management Studio.
- Find the project in the file system, locate the project configuration file (with ssmssqlproj extension), update “Sorted” property from “true” to “false” and save it.
- In Management Studio, open the project again and you can see that those items are sorted alphabetically.
However, if you have new items added in your project, the “Sort” property will be changed to “true” again and your new items are not sorted alphabetically either. You need to perform the above steps again to workaround this issue as I said it is really a workaround not a solution.