![sql server management studio download 2000 sql server management studio download 2000](https://qnehelp.azurewebsites.net/Content/Resources/Images/SQL_Management_Studio_Connect.png)
Now, the first thing that I did when I started using Management Studio was to tell it to start with an empty environment. The Object Explorer is a mix of the Object Browser within Query Analyzer and the Explorer part of Enterprise Manager. It's worth mentioning the Object Explorer and Summary page. My queries run nicely, it's all the one window, instead of swapping between Enterprise Manager and Query Analyzer all the time, and that's great.
![sql server management studio download 2000 sql server management studio download 2000](https://i.stack.imgur.com/XmuMO.png)
I can even use it to edit DTS packages, because I have the Feature Pack installed, including the SQL Server 2000 DTS Designer Components. Main benefits.įirstly, it really does work well. So I started to do the same, and thought I'd write down some of my tips. I asked him which of our customers he was using it for, and he said "All of them." Somehow, I had missed the fact that Management Studio works REALLY well with SQL2000 databases. A compromise.Ī while back, I was talking to the senior DBA where I work about some of the new SQL2005 things, and he mentioned that he loved using SQL2005's Management Studio. I now have several queries that have two versions - the one that I'm using on under SQL2000, and the one that I'll use when I get to use SQL2005 in production. I'm a developer rather than a DBA, and I happily try things out in SQL2005 when I see some way that I could use the new functionality. For a while, I just used a virtual machine for it, but when the release candidate came out, I installed it on my machine proper, and frequently try things out on SQL2005. I've had SQL2005 installed on my local machine for some time. SQL2005's Management Studio with SQL2000 Stuck in SQL2000 land