When I switched from Entreprise Manager to SQL Server Management Studio, like a lot of people, I was angered by that new piece of crap :
-It's slow (it takes several second to display the message and a memory hog.
-It feels buggy. Never had a trouble with entreprise manager but with server management studio I had several 'oops I fucked up here is my stack trace' message box. (It seems to happen a lot when you try to use stuff you don't have access to).
-Each time you create a new procedure/function you must remove all the useless auto-generated stub.
-You have to click WAY more than Entreprise manager. It's so damn annoying to click all the time to open that damn tree!
-Couldn't they find an even longer and meaningless name? I mean : 'SQL Server Management Studio Express'. Come on!
With some time that feeling vanishes and you start getting used to it. If I had the choice of the tool i'd probably keep the new server management studio
Here is what's nice with the new tool :
-mdi/tabs windows. I don't need to keep open multiple instances of entreprise manager. (Except for the relationship/index/contraints screens which are really fucked up.
-editing of text(stored procedure, table definition) is much nicer (search/replace with regex!)
-I can access to the database at a lower level : I can look at the create table statements, I can look at the system function/procedures,...
-Using the design table option does not lock the table!
-It's packed with a bunch of really cool features. It's really worth it to spend some time to discover some of the cool features
-I feel more at home thanks to the similarity with visual studio.
If you give it some time you'll start to like it more and more :).