Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Sever Management Studio for SQL Server 2000

We use mostly SQL Server 2005 but have a few SQL Server 2000 servers laying around. Is there a SQL Server Management Studio like application for SQL Server 2000?

Thank you.

like image 242
user141594 Avatar asked Nov 19 '09 13:11

user141594


2 Answers

SQL Server 2000 Management Tools includes Enterprise Manager (like Management Studio), Query Analizer (a tool to execute scripts) and Profiler (a tool to profile queries).

And you can connect and work in your SQL Management Studio 2005 with SQL Server 2000 :)

Or you can use EMS SQL Manager if you want something different.

like image 75
silent Avatar answered Oct 05 '22 01:10

silent


In SQL 2000, you can use Enterpise Manager to browse objects and perform many administrative tasks. You can use SQL Query Analyzer to write and run SQL, view query execution plans, etc. SQL Profiler can be used to profile queries.

However, you can use the SQL 2005 version of SQL Server Management Studio (SSMS) to connect to SQL 2000 servers and it works great.

like image 43
Joe Barone Avatar answered Oct 05 '22 01:10

Joe Barone