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

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

TomT (tomt (AT) newsgroup (DOT) nospam) writes:
You can install the new tools side-by-side with the 2005 tools, and you
can run them against SQL 2005 and SQL 2000.

It can be a good idea to keep the old tools, in case you need to instruct
a colleague or someone else how to do something, and the person you are
instructing only have the old tools.

It's not that the new tools are jam-packed with new features, but there
are enough goodies for me to warrant an installation on my work machine.
One thing I particularly like is that when I run my lock-mointor procedure
that includes the query plan for running queries and double-click on the
XML document, SSMS shortcuts and directly shows the graphical plan for
me. Love it! Another nice features is that you can configure what is
displayed on the tab strip.

And, oh, yes, intellisense is a new feature, but it's only enabled when
you are conneted to SQL 2008 instances. Personally, I can't stand it,
so I turn it off as quick as I can.

One thing to beware of is that import of your registred servers from SSMS
2005 appearently does not work. It asks if you want to do it, but it
fails if you accept...


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx