Well, contrary to the title you can’t…
I felt empty inside the other day and it was all because I kept adding queries to my SQL Server Management Studio (SSMS) project and they weren’t sorting at all. They just sat there in the order in which I added them to the project. The continuing problem is that you cannot sort the queries in SSMS.
Now this empty feeling is being shared by a few others, and what is probably an easy enhancement still waits for that full feeling of accomplishment. Please if you also have the time and the same empty feeling… vote on it!
Until then the guys over at SQLDBATips have created an external tool for sorting project files. So I guess I’ll only have a half empty feeling now.