SQL Server Management Studio: Difference between revisions

Content deleted Content added
m Added text to show in References for reference #5.
Compatibility: Added additional comments about options available depending on the version of SQL you connect to.
Line 8:
 
==Compatibility==
* Microsoft SQL Server 2008 R2 Management Studio (including the Express editionsedition) is backwards compatible with SQL Server 2000.<ref>[http://msdn.microsoft.com/en-us/library/ms174190.aspx Backwards Compatibility]</ref> The Management Studio only shows options based on the version of SQL Server you connect to. For example, when connecting the 2008 R2 edition of Management Studio to SQL Server 2000 to manage a database, the "Change Tracking" option is missing. When connecting the 2008 R2 edition of Management Studio to SQL Server 2008 R2, the "Change Tracking" option appears in the list when managing a database.
* The express edition can connect to a non-express version of SQL (with the limitations described above).