Generally speaking, I have always used SSMS (or the equivalent in some other version) for development. The integration of SourceSafe was a real boon to me, and most of our production databases have become SSMS solutions.
Recently we inherited an application, with database, where the database development was done in Studio Pro, resulting in .dbp projects. As far as I can tell, they are incompatible with SSMS solutions. Am I missing something in that?
For the bigger question, where SHOULD the development take place?
Buy the ticket, take the ride. -- Hunter S. Thompson