Replace SSMS 2005 with SSMS 2008

#11

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#12

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#13

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#14

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#15

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#16

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#17

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#18

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#19

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
<tomt (AT) newsgroup (DOT) nospam> wrote:

Quote:

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

#20

Aaron Bertrand [SQL Server MVP] wrote:

Quote:

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/sqlserv...spx?FeedbackID
=357349

On 8/22/08 5:17 PM, in article
95DC6846-82FC-4AD1-A799-3A36C2AB6021...soft (DOT) com, "TomT"
tomt (AT) newsgroup (DOT) nospam> 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

The one place I have found an issue is in fact the Activity Monitor.
The new activity monitor will not work against a SQL 2000 instance, and
unfortunately I still have quite a few instances that will not be
upgraded very soon.

To work around that issue - I have a side-by-side install and when I
need to use activity monitor I will just launch to 2005 SSMS and use that.

Jeff