Re: SQL Server 2000 EM vs. SQL Server 2005 MS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One final question: What should we expect in SQL 2008... any improvements say
better usage of the right panel etc.?
--
Regards,
MZeeshan


"Tibor Karaszi" wrote:

I'm confident that you will like SSMS more and more as you work with it. Remember that an all new
tool takes time to adjust to.

Of course, SSMS will mature over time, for instance based on feedback at
http://connect.microsoft.com/sqlserver. Some improvements were made in sp2, but a new version is
where MS has the chance to do more work.

Also, both tools (EM and SSMS) are based on some framework. EM is based on MMC and a lot of the
behavior you see is because of this (for instance non-modal dialogs). SSMS is based on Visual Studio
and I can imagine that with such a framework, you get certain behaviors, whether you like it or not.
I'm not saying this to argue one way or another, just to add some information into the picture.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"MZeeshan" <mzeeshan@xxxxxxxxxxxxxxxx> wrote in message
news:3D6A05AC-CE86-410F-99B9-9058976B245B@xxxxxxxxxxxxxxxx
I know how to write statements and queries; I was just trying to compare two
GUI tools :)

(b/w, as an MVP, are you implying that Microsoft is moving away from GUI
based approach to command line?)

And... I also agree that as a newer release the product will have more
features than the old one...

But, the point I was trying to make was the abrupt removal of some of the
very good features available in SQL EM and its ease of use. And, this is just
not my opinion as I wrote this after gathering similar feedback from other
DBAs.

May be, we used to SQL MS as we migrate totally towards 2005 but as of now
we are in transition and I have this annoyance and frustration when I use SQL
2005 MS after using SQL 2000 EM.

--
Regards,
MZeeshan


"Erland Sommarskog" wrote:

MZeeshan (mzeeshan@xxxxxxxxxxxxxxxx) writes:
One of the key differences we immediately noticed after upgrading to SQL
Server 2005 is the greatness of SQL Server 2000 EM -- its simplicity of
design, ease of use and the concept 'less is more'

For instance, if one wants to see the execution status of different
jobs, just expand the 'Jobs' (in Management --> SQL Server Agent) and
all the information appears on the right panel. No such luck with SQL
Server 2005 MS where surprisingly the right panel is useless most of the
time. The information requires multiple clicks to open multiple pop
windows, cluttering the desktop. Simple changes like switch to 'Single
User' mode requires search as it is hidden in the bottom of one of the
database properties' selection.

Does Microsoft recognize this? And, if yes, then are there any plans to
make things SIMPLER? (can we somehow use SQL EM with 2005... I know it's
a wishful thinking but it doesn't hurt to ask).

Personally, I think Mgmt Studio is great leap forwards compared to EM,
which was a real piece of crap in my opinion. Modal dialogs all over
the place. If you edit stored procedures through EM, ANSI_NULLS and
QUOTED_IDENTIFIER were off by default which is non-standard and does
not work with some functionality in SQL Server. Then again, some crap
were brought over as-is to SSMS, for instance the dreadful table designer.
Yes, the look is different. The bugs are exactly the same though.

On the other hand compared to Query Analyzer, SSMS has several weaknesses,
but QA was also a tool that was written with more understanding of
how SQL Server works.

As for the right panel being useless in SSMS, I don't agree. That's
they query window, and that's where I spend 99% of my time. For instance
setting the database in single-user mode:

ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

By the way, one great feature in SSMS, is that you can always get a
script for the command you are about to execute.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: SQL Server 2000 EM vs. SQL Server 2005 MS
    ... Of course, SSMS will mature over time, for instance based on feedback at http://connect.microsoft.com/sqlserver. ... Tibor Karaszi, SQL Server MVP ... > database properties' selection. ... not work with some functionality in SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • It can be Done
    ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 2005 Std Edition Installed, but not running
    ... I have 2 CDs labeled MICROSOFT SQL SERVER 2005 STANDARD EDITION and it comes ... with a product key I had to type in upon first install. ... Andrew J. Kelly SQL MVP ... thousands of others and have no problems running SSMS at all. ...
    (microsoft.public.sqlserver.setup)
  • Re: ssms not seeing local sql server
    ... I observed the same behavior as you did on the SQL 2005 Developer ... it simply doesnt show on the SSMS list). ... create a database... ... Rick Byham, SQL Server Books Online ...
    (microsoft.public.sqlserver.tools)