Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines?

SQL Server 2008 R2 works fine (what I have now).

share|improve this question
    
I did try searching for answers to this but my Google-Fu is weak today... –  Michael Haren Aug 21 '12 at 14:00
    
Yes, you can. I do it every day. –  zlatan Aug 21 '12 at 14:33
add comment

2 Answers

up vote 9 down vote accepted

Yes, I have done it. My website http://www.rocketclubs.com is on SQL server 2000 and I updated it last night in full windows 8, SSMS 2012 setup.

share|improve this answer
    
Just to be clear: you connected to SQL 2000 from SSMS 2012? Not upgraded? –  Michael Haren Aug 21 '12 at 14:05
    
Yes. No upgrading anywhere (I don't have the money to do anything like that). –  NickLarsen Aug 21 '12 at 14:07
    
Cool. Thanks very much! –  Michael Haren Aug 21 '12 at 14:07
3  
Note: SQL Server 2012 Profiler does not work with SQL Server 2000 –  Michael Haren Aug 21 '12 at 18:41
add comment

Yes, you absolutely CAN connect to a SQL Server 2000 instance using SSMS 2012 as a client. I do it every day as I still have 5 SQL Server 2000 instances in my environment that I manage. However, keep in mind that SSMS will present you with some options based on functions that are available in the version of SSMS you are using, and you may not be able to perform those functions from SSMS due to differences in commands between the versions.

And there are some things that SQL 2k simply doesn't like coming from SSMS. For example, if you use the GUI to manage permissions for a database role be prepared for SSMS to crash in some circumstances. For that reason it is always a good idea to keep a copy of SQL 2000 Enterprise Manager handy somewhere.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.