I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet.
However it seems to me, that the Management Studio works quite better and is at the first look very easy to use.
The basic functions for backing up, attaching and altering databases seems to work just fine!
The Diagram tool however has grown very poor! The GUI now has to leave room for one extra row at the bottom of each table in order not to show the vertical scrollbar – and showing the vertical often affects the horizontal space, also making this scrollbar appear! This is incredibly annoying! – why can’t they make a simple function to ‘shrink’ the table (in the diagram GUI) to the smallest possible size, and not showing the scrollbars for that reason? How hard can that be???
Also I experienced once, that although I’d saved several diagrams in my database, those diagrams dissapeared, once I reinstalled the server and re-attached the database-files. It seems the diagrams are not saved in the database itself, as they are in SQL 2000!
One thing is completely missing… The simple and fast interface from Query Analyzer from SQL 2000, when you only want to run basic T-SQL or like! For this purpose it seems to me, that there’s no reason to start up the entire Management Studio!
My experiences so far!