SQL Server Management Studio: Difference between revisions

Content deleted Content added
Compatibility: Added additional comments about options available depending on the version of SQL you connect to.
Added express edition section. Changed section title of Latest Version to Versions.
Line 5:
A central feature of SQL Server Management Studio is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.<ref>[http://msdn2.microsoft.com/en-us/library/ms173849.aspx MSDN: Using Object Explorer]</ref>
 
==Express Edition==
Microsoft has also introduced a graphicalfree configurationedition toolknown calledas '''SQL Server Management Studiothe Express''' (SSMSE) for [[SQL Server Express]]Edition.<ref>[http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en SQL Server Management Studio Express]</ref> As with all of Microsoft's "Express" products, this is downloadable as a standalone tool or integrated with a SQL Server Express edition at no charge. The tool's limitations lie in the fact that it cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, or SQL Server 2005 Mobile Edition.<ref>[http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en Download details: Microsoft SQL Server Management Studio Express<!-- Bot generated title -->]</ref>
 
* Determining which version you are using: When launching the express edition of 2008 R2, the application will not indicate that it is an express edition. The application title bar will read "Microsoft SQL Server Management Studio" even though you installed the express edition. Help/About will not reveal if it is an express edition.
 
==Compatibility==
Line 11 ⟶ 14:
* The express edition can connect to a non-express version of SQL (with the limitations described above).
 
==Latest VersionVersions==
* [http://www.microsoft.com/downloads/en/details.aspx?familyid=56AD557C-03E6-4369-9C1D-E81B33D8026B&displaylang=en Microsoft SQL Server 2008 R2 Management Studio Express]. Version 10.50.1600.1.