2

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?

Alex Angas
  • 2,017
  • 2
  • 26
  • 37
cori
  • 381
  • 1
  • 8
  • 16

3 Answers3

3

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.

squillman
  • 37,883
  • 12
  • 92
  • 146
  • 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
1

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.

palehorse
  • 4,299
  • 5
  • 29
  • 27
0

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

ggponti
  • 201
  • 3
  • 5