MZeeshan ( XXXX@XXXXX.COM ) writes:
Personally, I think Mgmt Studio is great leap forwards compared to EM,
which was a real piece of *** 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, XXXX@XXXXX.COM
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at