I don't know of any of the functionality that is missing. Some has changed,
for example Open Table has split into Select Top and Edit Top. And some
things have moved; I have seen many people complain that they can't find
Activity Monitor, because they looked only in the old place. But there is
definitely some new stuff. The only concern I have come across is that
loading a server in Object Explorer the first time can be VERY slow because
it loops through every single database to get object explorer details
information (even if object explorer details is not visible). On a shared
hosting environment where you need to expand the database list and there are
500 databases, and other people may be doing it at the same time, and the
server is not the beefiest thing in the world in the first place, this can
be a real time waster. I complained about this here but it hasn't received
much traction:

http://connect.microsoft.com/sqlserver/feedback/ViewFeedback.aspx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021@microsoft.com, "TomT"
wrote: