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.
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.
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.
Yes. It comes shipped with SQL Server 2000 and is called Enterprise Manager. It does not do everything SQL Server Management Studio does though (ie. like let you run queries - you have to use Query Analyzer for that).
You can use SQL Server Management Studio to connect to SQL 2000 though, so why not just use that?
Well, the management tools that actually shipped with SQL Server 2000 were:
SQL Server 2000 Query Analyzer, SQL Server 2000 Query Designer, SQL Server 2000 Profiler & SQL Server 2000 Enterprise Manager
The Enterprise Manager was the main management tool used to create & edit databases and schemas, stored procedures etc. and the Query Analyser tool was effectively the same as the Query Window in SQL Server 2005 Management Studio.
It s completely fine, however, to use the SQL Server 2005 Management Studio to administer and configure SQL Server 2000 database servers.
I use the sql server management studio 2005 tools on our sql 2000 server instances. We have licenses for both servers, and I found those tools easier to use than the old enterprise manager tools that come with sql 2000
There was a tool called DBAMgr2K which was extensive and did the job nicely and will handle SQL Server 2000 if you do not have SQL Management tools.
Hope this helps, Best regards, Tom.
I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management ...
What datatype is the most efficient to store a number such as 11.111. The numbers will have up 2 digits before the point and up to three after. Currently the column is a bigint , I am guessing that ...
是否需要在提瓜表之后更新表格统计数据,还是自动更新?
Ok, so I ve got a bit of a SQL and Powershell problem. There are 2 SQL scripts, one to setup 4 different global stored procedures. Another to execute them and manipulate data before returning it to PS ...
I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and ...
I am currently working on a particularly complex use-case. Simplifying below :) First, a client record has a many-to-one relationship with a collection of services, that is, a single client may have ...
I have a particularly troublesome xml column to query data from. The schema is fixed by the Quebec Ministry of Revenue so "it is what it is" The important part of the query looks like this: with ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
