@batasrki said:
What about it? I personally find it better than Enterprise Manager/Query Analyzer combo
Let's see, things off the top of my head...
1) Click on a NULL field to edit it. It actually leaves the text literal 'NULL' in the field and you need to backspace over it. I can't count the number of times I edit a field, look up, and it says 'NULLJohn'.
2) When editing a boolean field, you actually need to type in the full freaking word 'true' or 'false' instead of 1 or 0. Gone are the days of typing 1 DOWN 0 DOWN 1 DOWNN 0 DOWN 0 to quickly edit five records.
3) Open Table -> Query is gone. Instead we have 'Open Table' with NO option to put in a where clause before it starts returning every record in the entire table so you have to quickly hit the 'Stop Retrieving Data' button. You can do Script Table As -> Select To -> New Query Editor Window (side-scrolling menus THREE layers deep! Lovely!) but query editor window data is not editable.
4) If you copy data and paste into Excel*, it doesn't take the field names with it (Enterprise Manager did) and also keeps the NULL literal text for all null fields (Enterprise Manager didn't).
5) Whenever you open Management Studio, you get that utterly useless 'Summary' window that tells you nothing important.
6) In Enterprise Manger, you could press 'G' and it would jump to the tables starting with 'G'. That doesn't work in the tree view in Management Studio.
7) If you want to set a column as identity in Enterprise Manger, you double-click on the Identity row in the Columns section and it cycles through yes, no, and not for replication. If you want to set it in Management Studio, you need to scroll down the column properties, click the + to expand out 'Identity Specification' (double-clicking on it doesn't do anything) then double-click on 'Is Identity'. Three mouse clicks instead of one.
8) It's pretty much the same story with defining FK relationships -- many more mouse clicks, popup windows, and steps than before. Also, in Enterprise Manager you could select the PK table and FK table from dropdowns so you could define a relationship by either modifying the PK table or FK table. In Management Studio the FK table is greyed out and unchangable so you MUST define relationships by modifying the FK table only.
* Shaddup. I have clients that want dumps of data for mail merges, financial analysis, etc. and Excel is the only common denominator we have.