HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is is possible to manage SQL Server 2008 databases via R2 Management Studio?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2008databasessqlmanagemanagementpossibleviastudioserver

Problem

Is it possible to manage SQL Server 2008 databases using SQL Server 2008 R2 Management Studio?

Solution

Yes, it is possible to use the SSMS from R2 to connect to a database server from any of the previous versions (I'm not sure about version pre SQL 2000, but it's not your case anyways).

You won't have all possible features activated (like Utility Explorer), but that shouldn't stop you to use it properly.

Context

StackExchange Database Administrators Q#7459, answer score: 6

Revisions (0)

No revisions yet.