什麼是 SQL Server Management Studio (SSMS)?What is SQL Server Management Studio (SSMS)?

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server Management StudioSQL Server Management Studio (SSMS) 是用於管理任何 SQL 基礎結構的整合式環境。(SSMS) is an integrated environment for managing any SQL infrastructure. 使用 SSMS 來存取、設定、管理、掌管和開發 SQL ServerSQL Server、Azure SQL Database 和 SQL 資料倉儲的所有元件。Use SSMS to access, configure, manage, administer, and develop all components of SQL ServerSQL Server, Azure SQL Database, and SQL Data Warehouse. SSMS 能提供單一的完整公用程式,結合了廣泛的圖形工具和豐富的指令碼編輯器,使開發人員和資料庫管理員 (不管他們的技術水準如何) 都能夠存取 SQL ServerSQL ServerSSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL ServerSQL Server for developers and database administrators of all skill levels.

SQL Server Management Studio 元件SQL Server Management Studio components

DescriptionDescription 元件Component
使用 物件總管 檢視及管理一個或多個 SQL ServerSQL Server執行個體中的所有物件。Use Object Explorer to view and manage all of the objects in one or more instances of SQL ServerSQL Server. 物件總管Object Explorer
如何使用 [範本總管] 建立及管理重複使用文字的檔案,以用來加快查詢與指令碼的開發速度。How to use Template Explorer to build and manage files of boilerplate text that you use to speed the development of queries and scripts. 範本總管Template Explorer
如何使用即將淘汰的 方案總管 建立專案,以管理管理項目 (例如指令碼與查詢)。How to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries. 方案總管Solution Explorer
如何使用 Management StudioManagement Studio隨附的視覺化設計工具。How to use the visual design tools included in Management StudioManagement Studio. Visual Database ToolsVisual Database Tools
如何使用 Management StudioManagement Studio 語言編輯器以互動的方式建立查詢與指令碼,以及對其執行偵錯。How to use the Management StudioManagement Studio language editors to interactively build and debug queries and scripts. 查詢與文字編輯器 (SQL Server Management Studio)Query and Text Editors (SQL Server Management Studio)

適用於商業智慧的 SQL Server Management StudioSQL Server Management Studio for Business Intelligence

若要存取、設定及管理 Analysis ServicesAnalysis ServicesIntegration ServicesIntegration ServicesReporting ServicesReporting Services,請使用 SQL Server Management StudioSQL Server Management StudioTo access, configure, manage, and administer Analysis ServicesAnalysis Services, Integration ServicesIntegration Services, and Reporting ServicesReporting Services, use SQL Server Management StudioSQL Server Management Studio. 雖然這三種商業智慧技術全都依賴 SQL Server Management StudioSQL Server Management Studio,但是與每一項技術有關的管理工作則會有些微的差異。Although all three business intelligence technologies rely on SQL Server Management StudioSQL Server Management Studio, the administrative tasks associated with each of these technologies are slightly different.

注意

若要建立及修改 Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesIntegration ServicesIntegration Services 解決方案,請使用 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT),而不要使用 SQL Server Management StudioSQL Server Management StudioTo create and modify Analysis ServicesAnalysis Services, Reporting ServicesReporting Services, and Integration ServicesIntegration Services solutions, use SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), not SQL Server Management StudioSQL Server Management Studio. SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) 是一個以 MicrosoftMicrosoftVisual StudioVisual Studio為根據的開發環境。is a development environment that is based on MicrosoftMicrosoftVisual StudioVisual Studio.

使用 SQL Server Management Studio 管理 Analysis Services 解決方案Managing Analysis Services Solutions Using SQL Server Management Studio

SQL Server Management StudioSQL Server Management Studio 可讓您管理 Analysis ServicesAnalysis Services 物件,例如執行備份及處理物件。enables you to manage Analysis ServicesAnalysis Services objects, such as performing back-ups and processing objects.

Management StudioManagement Studio 會提供一個 Analysis ServicesAnalysis Services 指令碼專案,您可在其中開發及儲存使用多維度運算式 (MDX)、資料採礦延伸模組 (DMX) 和 XML for Analysis (XMLA) 所撰寫的指令碼。provides an Analysis ServicesAnalysis Services Script project in which you develop and save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). 您可以使用 Analysis ServicesAnalysis Services 指令碼專案來執行管理工作或是在 Analysis ServicesAnalysis Services 執行個體上重新建立物件,例如資料庫和 Cube。You use Analysis ServicesAnalysis Services Scripts projects to perform management tasks or re-create objects, such as database and cubes, on Analysis ServicesAnalysis Services instances. 例如,您可以在 Analysis ServicesAnalysis Services 指令碼專案中開發 XMLA 指令碼,該指令碼會直接在現有的 Analysis ServicesAnalysis Services 執行個體上建立新的物件。For example, you can develop an XMLA script in an Analysis ServicesAnalysis Services Script project that creates new objects directly on an existing Analysis ServicesAnalysis Services instance. Analysis ServicesAnalysis Services 指令碼專案可儲存成為方案的一部分,並與原始程式碼控制整合。The Analysis ServicesAnalysis Services Scripts projects can be saved as part of a solution and integrated with source code control.

如需如何使用 SQL Server Management StudioSQL Server Management Studio的詳細資訊,請參閱 使用 SQL Server Management Studio 進行開發和實作For more information about how to use SQL Server Management StudioSQL Server Management Studio, see Developing and Implementing Using SQL Server Management Studio.

使用 SQL Server Management Studio 管理 Integration Services 解決方案Managing Integration Services Solutions Using SQL Server Management Studio

SQL Server Management StudioSQL Server Management Studio 可讓您使用 Integration ServicesIntegration Services 服務來管理套件及監視執行中的套件。enables you to use the Integration ServicesIntegration Services service to manage packages and monitor running packages. 您也可以使用 Management StudioManagement Studio 將封裝組織成資料夾、執行封裝、匯入及匯出封裝、移轉 Data Transformation Services (DTS) 封裝及升級 Integration ServicesIntegration Services 封裝。You can also use Management StudioManagement Studio to organize packages into folders, run packages, import and export packages, migrate Data Transformation Services (DTS) packages, and upgrade Integration ServicesIntegration Services packages.

使用 SQL Server Management Studio 來管理 Reporting Services 專案Managing Reporting Services Projects Using SQL Server Management Studio

使用 SQL Server Management Studio 可啟用 Reporting Services 功能、管理服務和資料庫,以及管理角色和作業。Use SQL Server Management Studio to enable Reporting Services features, administer the server and databases, and manage roles and jobs.

您可使用 [共用排程] 資料夾來管理共用排程,並管理報表伺服器資料庫 (ReportServer、ReportServerTempdb)。You manage shared schedules by using the Shared Schedules folder, and manage report server databases (ReportServer, ReportServerTempdb). 當您將報表伺服器資料庫移到新的或另一個 SQL Server Database Engine (SQL ServerSQL Server Database EngineDatabase Engine) 時,您也會在 Master 系統資料庫中建立 RSExecRole。You also create a RSExecRole in the Master system database when you move a report server database to a new or different SQL Server Database Engine (SQL ServerSQL Server Database EngineDatabase Engine). 如需有關這些工作的詳細資訊,請參閱下列主題:For more information about these tasks, see the following topics:

您也可以透過以下方式來管理伺服器:啟用及設定各種功能、設定伺服器預設值及管理角色和作業。You also manage the server by enabling and configuring various features, setting server defaults, and managing roles and jobs. 如需有關這些工作的詳細資訊,請參閱下列主題:For more information about these tasks, see the following topics:

非英文版本的 SQL Server Management Studio (SSMS)Non-English language versions of SQL Server Management Studio (SSMS)

已解除封鎖混合語言安裝。The block on mixed languages setup has been lifted. 您可以在法文版 Windows 上安裝 SSMS 德文版。You can install SSMS German on a French Windows. 如果作業系統語言與 SSMS 語言不相符,則使用者必須在 [工具] > [選項] > [國際設定] 下變更語言,If the OS language doesn't match the SSMS language, the user needs to change the language under Tools > Options > International Settings. 否則 SSMS 會顯示英文的 UI。Otherwise, SSMS shows the English UI.

如需舊版不同地區設定的詳細資訊,請參閱安裝非英文版本的 SSMSFor more information about different locale with previous versions, reference Install non-English language versions of SSMS.

SSMS 的支援原則Support Policy for SSMS

info_tip 取得說明Get Help

後續步驟Next steps

編輯內容 參與 SQL 文件Contribute SQL documentation

您知道您可以自己編輯內容嗎?Did you know that you could edit the content yourself? 如果您這樣做,不只會改善我們的文件,而且您也會成為該頁面的參與者!If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.