Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have been logging in to the server to use the SQL Server 2000 tools installed there to manage permissions and perform other admin tasks.

Would it be a problem to use SQL Server 2005 from my client machine for this purpose?

share|improve this question

3 Answers 3

up vote 3 down vote accepted

No, you should be good. There are a couple of things you might not be able to do (such as playing with DTS) but by and large you're good. I did the same thing until we upgraded our servers to 2005. Now am doing the same thing using SSMS 2008 with SQL 2005 servers.

share|improve this answer
    
Thanks for the added detail, too! –  cori May 11 '09 at 16:57
    
You can manage the DTS too if you install the backwards compatibility components from the Microsoft site. Just found this and it works great. –  Swinders Jun 23 '09 at 11:44

In my experience, if the operation you are trying to do can't or should not be done with SQMS, it will not let you do it. You will get an exception. If it lets you perform the operation, it should be fine.

share|improve this answer
    
that's kind of what I thought, but it's always good to have confirmation. –  cori May 11 '09 at 16:57
    
Yeah, I hear you there, especially when production environments are concerned! –  palehorse May 11 '09 at 17:25

You may also want to install the Microsoft SQL Server 2005 Backward Compatibility Components.

share|improve this answer

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.