Sql server 2000 management studio windows 7

I have just upgraded to a 64 bit widows 7 machine from a windows xp machine. I need to have ms sql server management studio express to manage a sql 2000 db as well as a sql
2005 db; I used to have this on my xp machine. My tech rep pointed me to:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=76ea83da-4797-4f11-a834-456ee9dc3764 soI
went there and downloaded and installed the: ENUx64SQLServer2005_SSMSEE.msi.

the install went fine, I ran some queries and and all seemed fine. I’m not quite sure just when thigs started to go wrong but I think it was when I tried to modify and run a view;
my query returned no recordsand then some things took a very long time to run. then I got an error that said that there wasn’t enough space to run the query that I was trying to run and eventually the circle just kept spinning. So, I shut it down and
restarted. I was able to modify a view and run the query and it ran fine but when I tried to open a file and run the next query, the spinning circle happened again and was spining for about ten minutes and then it shut down.

I started it again and run one query fine but the next one, it said retrieving data but just sat for a long time. I clicked back on the query, got the spinning circle again and
then it just shut itself down again. All of this works well and quickly on my xp machine.

I have to confess that I didn’t install the  .NET Framework 2.0, but as it said, if you have already installed SQL Server 2005 or Visual Studio 2005, you already have
Microsoft .NET Framework 2.0. and I also didn’t install the latest Microsoft Core XML Services (MSXML) 6.0 version mostly
because I didn’t read the full page because the file download was at the begining so I didn’t go any further — dim-witted I know.

So, I went back and installed the  .NET Framework 2.0 which was actually 4.0; and I tried to install the latest
Microsoft Core XML Services (MSXML) 6.0 version but
I didn’t know whether to install msxml6-KB954459-enu-amd64.exe or msxml6-KB954459-enu-ia64.exe

I googled what is the differnce between msxml6-KB954459-enu-amd64.exe and msxml6-KB954459-enu-ia64.exe but got only two results in English, one of which was  an article entitled
Description of the security update for XML Core Services 6.0: November 11, 2008 it said «This article applies to a different version of Windows than the one you are using. Content in this article may not be relevant to you.»‘ but I didn’t know to which version
it was referring, and a second one entitled Security Update for Microsoft XML Core Services 6.0 (KB954459) which included downloads for both version.

I am, due to lack of knowledge, daunted by the descriptions and caveats for installing and upgrading and updates, so I appeal to you. I’ve gone on at length but am trying to give
you as much information as possible — and then some.

I tried again after restarting my system and after one query and a view update, I got a system.outofmemory error thrown.

I know that Kate will have her challenges but she will never have to figure out stuff like this!

I doubt that I’ve even selected the right forum.

Any help would be appreciated.

Thanks

Microsoft SQL Server Management Studio (SSMS) is an all-in-one place for you to go if you want to manage your databases. SSMS gives you a graphical interface so you can manage your SQL databases from a local SQL server to an on-cloud database stack.

The SQL Server Management Studio can be used to deploy, monitor, and upgrade existing SQL databases. Some might even consider it an all-in-one solution.

This article gives you direct download links for all available SSMS versions that you can use to meet your requirements. But before we begin, let us give you a little insight into the different requirements and prerequisites.

As mentioned above, SQL Server Management Studio, or SSMS, is an integrated management environment for a SQL Server architecture. It offers a user interface, a set of tools, and sophisticated script editors that communicate with SQL Server.

The user-friendly interface and convenient manageability of the SSMS make it easier for the developers to manage the many SQL databases, perform maintenance works, and access them when required.

SQL Server Management Studio System Requirements

Before you begin installing SSMS on your device, you’ll need to meet these minimum hardware requirements:

• Processor: 1.8 GHz or faster x86 (Intel, AMD) processor
• RAM: 2GB (2.5GB if running on a virtual machine)
• Storage: Minimum of 2 GB (Can go up to 10 GB depending upon installed features)

Apart from the hardware requirements, you also need to ensure that you have the right operating system. The following operating systems are currently supported:

• Windows Server 2022 (64-bit)
• Windows 11 (64-bit)
• Windows 10 (64-bit) version 1607 (10.0.14393) or later
• Windows 8.1 (64-bit)
• Windows Server 2019 (64-bit)
• Windows Server 2016 (64-bit)
• Windows Server 2012 R2 (64-bit)
• Windows Server 2012 (64-bit)
• Windows Server 2008 R2 (64-bit)

Download all versions of Windows Server.

SQL Server Management Studio Download Links

Here’s the list of the latest builds of SQL Server Management Studio. Click the Download button to immediately begin downloading the tool.

You can also download a specific version if you don’t want the latest build of SSMS:

There have also been preview releases for some of these versions that have not been mentioned in the table above.

To download any SSMS version in any other language, please visit Microsoft’s Release Notes page for direct download links.

How to Install SQL Server Management Studio

Once you have downloaded the SSMS, here is how to install it:

1. Download the setup file for the SSMS version from the given links above.

2. Run the downloaded file.

   The installation wizard will then run.

3. Click Install.

   

   SSMS will now begin installing on your PC. The process should take about 5 minutes but can vary depending on your system’s specifications.

4. Once installed, click Close.

   

You can now launch SSMS by searching for it through the Windows Search bar and begin using it.

SQL Server Management Studio Available Languages

SSMS can be downloaded and installed in the following languages:

• English (US)
• Chinese (Simplified)
• Chinese (Traditional)
• French
• German
• Italian
• Japanese
• Korean
• Portuguese (Brazil)
• Russian
• Spanish

Uninstall SQL Server Management Studio

If you ever want to uninstall the SSMS, here is how to do it:

1. Run the downloaded setup file for SSMS previously used for installation.

   If you don’t already have it, you can download the setup file from the direct download links shared above.

2. Click Uninstall from the wizard.

   

   The wizard will then remove SSMS from your device.

3. Click Close when it is finished.

   

FAQs

Also see:

SQL2005’s Management Studio with SQL2000

Stuck in SQL2000 land

I’ve had SQL2005 installed on my local machine for some time. 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’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. 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.

A compromise…

A 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 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. So I started to do the same, and thought I’d write down some of my tips.

Main benefits…

Firstly, it really does work well. It feels like it’s supposed to. I can even use it to edit DTS packages, because I have the Feature Pack installed, including the SQL Server 2000 DTS Designer Components. 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.

Object Explorer and Summary page

It’s worth mentioning the Object Explorer and Summary page. The Object Explorer is a mix of the Object Browser within Query Analyzer and the Explorer part of Enterprise Manager. Now, the first thing that I did when I started using Management Studio was to tell it to start with an empty environment. I don’t need it trying to connect anywhere before I’ve decided which particular server I want to connect to. But then I came to a situation where I wanted to delete about 5 tables, and I couldn’t see how to do that easily in Management Studio. So I asked a friend, and he said «Use the Summary page». Doh! Of course. I pressed F7, up it popped, and it showed me everything I needed. Gives me lists of the things that are within the selected item in the Object Explorer. It’s handy, but to be honest, I rarely use it. I would rather have a query window there, which is what I do!

Renaming registered servers

Object Explorer is really great, of course. I love being able to see the linked servers. I love the grouping of functions into table, scalar and system. The way that the windows can dock is great. Personally, I think I’m typically going to use the default layout, but it’s great to have windows like the Registered Servers pane able to auto-hide when you don’t want them. And speaking of Registered Servers — it’s great to finally be able to change the display-name of servers. No more IP addresses or annoyingly named servers for me. I can call them useful things like «Test Server in Sydney» or «Production Server for client XYZ», or «DON’T USE THIS ONE, but if you really need to, then it’s Jeremy’s» — and Management Studio still does the friendly thing of putting the address/servername in brackets after my own description.

Go handled properly

Here’s a thing I came across the other day which has won me over even more:

How many times do you have a bunch of code that you want to comment out in Query Analyzer, so you put a /* and later, put a */. Then you run it, and you find that there was a ‘go’ in there somewhere, giving you not only an error saying that it couldn’t find the pairs of the comment brackets, but also running anything in between that you really didn’t want to have run! Well, Management Studio is nicer than that. A ‘go’ statement surrounded by comment brackets is also ignored. So there’s no need to highlight it all and do Ctrl-Shift-C (or Ctrl-K, Ctrl-C in Management Studio). Actually, there’s another thing — commenting is now consistent with Visual Studio. This is a tremendous thing for anyone in the developer space. Probably not so great if you’re a DBA, but I find it good. I do wish that Ctrl-Shift-C still worked, but only because there are times I hit it and find that nothing happened. And you can now undo comments! In Query Analyzer, I used to get really frustrated that I couldn’t hit Ctrl-Z and undo my bulk-comment. But now, Ctrl-Z will undo a Ctrl-K, Ctrl-C. And I’m a much less frustrated coder.

use pubs
go
select * from authors
/*
select * from titles
go
select * from employee
*/select * from jobs

Copying works better

How much did you hate copying stuff out of the grid in Query Analyzer. You’d copy it, paste it into another query, and automatically hit delete to remove the newline character that it put in there for you. Now, it doesn’t put the newline in there. I know this could be annoying if you want it, but frankly, I don’t! I like the fact that I can now paste a string in between two apostrophes, and not have to hit backspace immediately.

Movement

Finally, I want to point out that Management Studio understands words much better than Query Analyzer. If I use Ctrl-Left or Ctrl-Right to move through a string (let’s say, a URL) in Query Analyzer, then it consider that each word ends at whitespace. Aargh! That used to kill me. But Management Studio will stop at each dot, hyphen, plus, you name it! Unless you name it ‘underscore’ — they get ignored, but that’s fair enough, because underscores are different. I know that if you like the way that Query Analyzer handled these things, then you might get frustrated by Management Studio, but is there really anyone out there who will find that?

So my conclusion…

I have to recommend using Management Studio to anyone who uses SQL2000. If nothing else, you’ll find yourself looking forward to when you get the clearance to use SQL2005 itself. But even if SQL2005 isn’t on the horizon, you can use a much nicer interface to the SQL2000 databases you do have.