SQL Server Management Studio: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 11:46, 30 November 2008 edit WOSlinker (talk \| contribs) Administrators 861,409 edits add cat ← Previous edit		Latest revision as of 17:00, 13 August 2025 edit undo SixSix (talk \| contribs) Extended confirmed users 2,338 edits m Bump version number Tag: Visual edit: Switched
(243 intermediate revisions by more than 100 users not shown)
Line 1: {{Short description\|Database management software application}} [[Image:SQLServerManagementStudio.JPG\|right\|thumb\|Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance.]]▼ {{redirect\|SSMS\|the type of mass spectrometer using [[spark ionization]]\|spark source mass spectrometer}} '''SQL Server Management Studio''' is a tool included with [[Microsoft]] [[Microsoft SQL Server\|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.<ref>[http://msdn2.microsoft.com/en-us/library/ms174173.aspx MSDN: Introducing SQL Server Management Studio]</ref>▼ {{Infobox software 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> ~~[[ja:Microsoft~~\| name = SQL Server Management Studio]]▼ \| logo = MSSQL SSMS 21 icon.png \| screenshot = SQLServerManagementStudio.JPG ▲~~[[Image:SQLServerManagementStudio.JPG\|right\|thumb~~\| caption = Earlier version of Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance.]] \| collapsible = \| author = \| developer = Microsoft \| released = 2005 \| discontinued = \| latest release version = <!-- If you update this, remember to also update [[Comparison of database tools]]-->21.4.12<ref name="ssms_release">{{cite web \|url=https://learn.microsoft.com/ssms/install/install \|title=Install SQL Server Management Studio \|date=2025-08-12 \|accessdate=2025-08-13}}</ref> \| latest release date = {{Start date and age\|2025\|08\|12}} \| programming language = \| operating system = [[Microsoft Windows]] \| platform = \| size = \| language = Chinese (Simplified), Chinese (Traditional), Czech, English (United States), French, German, Italian, Japanese, Korean, Polish, Portuguese (Brazil), Russian, Spanish, Turkish \| genre = \| license = \| website = {{URL\|https://learn.microsoft.com/ssms/sql-server-management-studio-ssms}} }} ▲'''Microsoft SQL Server Management Studio''' ('''SSMS''') is a ~~tool~~software ~~included~~application ~~with~~developed ~~[[Microsoft]]~~by [[Microsoft ~~SQL Server\|SQL Server 2005~~]] ~~and~~that ~~later~~is ~~versions~~used for configuring, managing, and administering all components within [[Microsoft SQL Server]]. First launched with Microsoft SQL Server 2005, it is the successor to the '''Enterprise Manager''' in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.<ref>~~[http~~{{cite web\|url=https://~~msdn2~~docs.microsoft.com/en-us/~~library~~sql/~~ms174173.aspx~~ssms/sql-server-management-studio-ssms?view=sql-server-ver16 ~~MSDN:~~\|title=What ~~Introducing~~is SQL Server Management Studio] (SSMS)? \|date=2022-01-28 \|website=microsoft.com \|accessdate=2022-07-14}}</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 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> A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.<ref>{{cite web \|url=https://docs.microsoft.com/en-us/sql/ssms/object/manage-objects-by-using-object-explorer?view=sql-server-ver16= \|website=microsoft.com \|title=Manage Objects by Using Object Explorer \|date=2022-01-18 \|accessdate=2022-07-14}}</ref> It also shipped a separate Express edition that could be freely downloaded; however recent versions of SSMS are fully capable of connecting to and manage any SQL Server Express instance. Microsoft also incorporated backwards compatibility for older versions of SQL Server thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately. ==References==▼ ~~<references/>~~ Starting from version 11, the application was based on the [[Microsoft Visual Studio#Visual Studio 2010\|Visual Studio 2010]] shell, using [[Windows Presentation Foundation\|WPF]] for the user interface. Versions 18 and after are based on the [[Microsoft Visual Studio#2017\|Visual Studio 2017]] [[Microsoft Visual Studio#Extensibility\|Isolated Shell]].<ref>{{cite web\|title=SSMS 18.0 (preview 4)\|url=https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017#ssms-180-preview-4download-sql-server-management-studio-ssmsmd\|website=SQL Server Management Studio - Changelog (SSMS)\|publisher=Microsoft\|access-date=22 October 2018\|date=24 September 2018}}</ref> In June 2015, Microsoft announced their intention to release future versions of SSMS independently of SQL Server database engine releases.<ref>{{cite web\|title=Announcing SQL Server Management Studio – June 2015 Release\|url=https://docs.microsoft.com/en-us/archive/blogs/sqlreleaseservices/announcing-sql-server-management-studio-june-2015-release\|website=SQL Release Services Blog\|publisher=Microsoft\|access-date=7 September 2015\|date=24 June 2015}}</ref> Since version 21 SSMS is based on [[Microsoft Visual Studio#2022\|Visual Studio 2022]] and is installed using the Visual Studio Installer. <ref>{{cite web\|title=Release notes for SQL Server Management Studio (SSMS)\|url=https://learn.microsoft.com/en-us/ssms/release-notes-21\|website= Microsoft Learn\|publisher=Microsoft\|date=19 May 2025}}</ref> ==See also== * [[Comparison of database administration tools]] * [[SQL Server Management Objects]] ▲==References== {{reflist\|2}} ==External links== * [~~http~~https://~~articles~~learn.~~techrepublic.com~~microsoft.com/~~5100~~ssms/sql-~~9592_11~~server-~~6033513.html 10 things you should know about~~management-studio-ssms SQL Server ~~2005~~ Management Studio (SSMS)] * [http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&displaylang=en SQL Server 2008 Management Tools] * [http://www.sqlmag.com/articles/index.cfm?articleid=46798& SQL Server 2005 Management Tools] * [http://www.ssmstoolspack.com SSMS Tools PACK] {{MS DevTools}} {{Microsoft-stub}}▼ [[Category:Microsoft database software]] [[Category:Database administration tools]] ▲{{Microsoft-software-stub}} ▲[[ja:Microsoft SQL Server Management Studio]]