SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.[1]
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.[2]
Microsoft has also introduced a graphical configuration tool called SQL Server Management Studio Express (SSMSE) for SQL Server Express.[3] 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.[4]
Compatibility
- Microsoft SQL Server Management Studio (including Express editions) is backwards compatible with SQL 2000.[5]
- The express edition can connect to a non-express version of SQL (with the limitations described above).
Latest Version
- Microsoft SQL Server 2008 R2 Management Studio Express. Version 10.50.1600.1.
See also
References
External links
- SQL Server 2008 Express With Management Tools
- SQL Server 2005 Management Tools (Subscription Required)
- Microsoft SQL Server Management Studio Express 2008
 | This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it. |