Can I add sub folders to a SQL Server Management Studio Project?

Question

What is the best way to keep large projects organized with SSMS?

I want to do something like:

ProjectRoot
    SchemaObjects
        Tables
            Constraints
            Indexes
            Keys
        Functions
        Views
        Stored Procedures
     Scripts
         DataGeneration

And so on, but I cannot find a nice way to do this... Any suggestions?

Answer 1

I don't think there's anyway way to do this in SMSS, at least not in 2005. Maybe a third party tool will give you this; there's a list of replacements for 2000 Enterprise Manager here; not the most current, but probably a good starting point.

Answer 2

Sadly there isn't. Maintain your object scripts out side of SSMS and simply edit them in SSMS.

IMHO this is one thing that is lacking big time in SSMS.

Answer 3

There's a new plugin available Management Studio 2005 Plugin. It can help with organizing your queries...