Workaround: Items are not sorted alphabetically in the SQL Server Management Studio Solution Explorer

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:

image

The workaround to let them sorted by alphabet is to change the “Sorted” property from “true” to “false”. Here are steps in detail:

  1. Save and close your solution from Management Studio.
  2. 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.
    image
  3. In Management Studio, open the project again and you can see that those items are sorted alphabetically.
    image

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.

HTH 🙂

Advertisements

About Alex Feng

SQL Server DBA in Alibaba Cloud Computing
This entry was posted in Tools, Uncategorized and tagged , . Bookmark the permalink.

One Response to Workaround: Items are not sorted alphabetically in the SQL Server Management Studio Solution Explorer

  1. Alex Feng says:

    I want to add a comment here. I found another better solution to resolve this annoy issue with one-click, please check Jasper Simith’s Blog post: http://www.sqldbatips.com/showarticle.asp?ID=78.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s