Personally, I like SSMS. I spend most of my day working in it and rarely close it. I don't use SSIS or the data tools in VS because SSMS does everything I need - it gives me an object explorer and a T-SQL window. Yeah, some of the other stuff is nice, but I don't use the View Designer or Table Designer. In fact, I'd probably disable the View Designer if I could. 😛