Re: Replace SSMS 2005 with SSMS 2008



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@xxxxxxxxxxxxx, "TomT"
<tomt@xxxxxxxxxxxxxxxx> wrote:

Are there any problems or issues in replacing just SSMS 2005 with the new
version - I'd like to get familiar with it, but we have not yet upgraded our
databases to 2008 (they are, except for 2, 2005).

I'm hoping to do this only on my client/dev system, which I use to connect
to our SQL 2005 servers.

Thanks

.



Relevant Pages

  • Re: Mobile Only? Why?
    ... You should get a Database Engine query window. ... Microsoft, SQL Server Books Online ... >> - On the Object Explorer toolbar, click Connect, and then click Database ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem display database list on remote server
    ... Actually I just noticed that you are using SSMS Express, ... SSMS Express have an Object Explorer Details pane? ... SSMS Express 2008 to access our database on ... the server of our hoster. ...
    (microsoft.public.sqlserver.tools)
  • Re: Cannot create diagrams in SQLSERVER 2005
    ... > Every time I click on the Database Diagram node in object explorer in SQL ... This typically happens when you migrate a database from another server. ...
    (microsoft.public.sqlserver.tools)
  • Re: Change file location om SQL 2005
    ... Open Management Studio and connect to the instance with Object Explorer. ... Right Click the instance and choose Properties.Select the Database Settings ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 916 When Connecting SQL Server 2008 Management Studio To SQL
    ... Manger in SQL 2000 that had the same flaw.) ... If you are not permitted in that database, ... when Object Explorer Details is not even visible. ...
    (microsoft.public.sqlserver.tools)

Loading