How do I get a copy of MS SQL Enterprise Manager and Query Analyzer?

NOTE: We strongly recommend migrating from SQL 2000 to SQL 2005 or 2008. As Microsoft continues to move forward with SQL server technology, SQL 2000 will fall further behind the standard. It is no longer actively developed or updated, as it has been superseded by SQL 2005 and 2008. While we will continue to maintain our existing SQL 2000 servers, our recommendation is to upgrade your SQL service to a more recent version at your earliest possible convenience.

If you decide to migrate your SQL database we have a forum post on the steps needed to complete this process.

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL Server installation.

An inexpensive alternative (under $50.00) is to purchase Microsoft SQL Server 2000 Developer Edition. This provides the complete Enterprise Edition with 2 restrictions. (1) No commercial usage. Development and Testing only. (2) Limited to 8 simultaneous connections. This in not an evaluation or Academic Edition. Low prices can be found at amazon.com or provantage.com.

Article ID: 216, Created On: 11/14/2008, Modified: 4/7/2011