I tried very hard to use the Solution Explorer functionality in SQL 2005 but quit as soon as I saw that it didn't alphabetize scripts.
After a long wait we have SQL 2008 and I'm again trying to use the Solution functionality. I have a solution and a project and it does correctly alphabetize scripts.
The project that I'm trying to use has about 500 scripts and I have them in folders by catetory - reports, utilities, triggers, db specific, etc. I don't see any way to add folders to a project/solution like you can in Visual Studio. Am I missing anthing? Do I have to wait 3 more years?
To restate: I need a project with 500 scripts, and the scripts need to be in folders (and subfolders)