SQL Server Management Studio: Difference between revisions

Revision as of 14:35, 23 September 2010

Revision as of 14:38, 23 September 2010

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>

Microsoft has also introduced a graphical configuration tool called '''SQL Server Management Studio Express''' (SSMSE) for [[SQL Server Express]].<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>

SQL management studio is the principal database administration portal for Microsoft SQL databases and many database administrators spend a large percentage of time in the software to perform their job responsibilities.^{[citation needed]}