Hello,
Can SQL Server Management Studio manage table schemas and perform queries in respect of remote SQL 2000 databases, or do I have to use Enterprise Manager instead?
Thank you
SQL Management Studio works fine to manage SQL 2000 Databases. The only problem I have had is creating Maintenance Jobs for backups and such. I have scripted all of that since and have not had any problems.
Cheers!
SQL Server Management Studio is designed to work with SQL Server 2005 and SQL Server 2000. Some of the newer features like Management Studio reports are not backwards compatible with SQL Server 2000.
Here is a site we recently put together that can give you an overview of our technologies in SQL Server 2005: http://www.microsoft.com/sql/technologies/manageability/default.mspx.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
