KB3007905-更新為在 SQL Server Management Studio 2014 中建立 SQL Azure 資料庫的範本腳本

徵狀

假設您使用 Microsoft SQL Server Management Studio 2014 （SSMS 2014）連線到 Microsoft SQL Azure 資料庫。 在 Management Studio 中，當您以滑鼠右鍵按一下 [ 資料庫]，然後按一下 [ 新增資料庫 ] 命令時，範本腳本如下所示：

-- ======================================================================-- Create database template for a SQL Azure database-- This script will run only in the context of the master database.-- To manage this database in SQL Server Management Studio, either connect  -- to the created database, or connect to master.-- =======================================================================CREATE DATABASE <Database_Name, sysname, Database_Name>GO

此腳本不包含 SQL Azure 專用選項（例如EDITION 和 SERVICE_OBJECTIVE）。

解決方案

套用此熱修復程式後，範本腳本如下所示： = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = [= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =--建立 Azure SQL Database 的資料庫範本----此腳本只會在主資料庫的內容中執行。 若要在 SQL Server Management Studio 中管理此資料庫，請連線至建立的資料庫，或連線至 master。----SQL Database 是一種結構化的服務，可讓雲端架構師與開發人員輕鬆存取可預知的效能、可伸縮性、商務-連續性、資料保護及安全性，以及近零管理，這一切都是由 Microsoft Azure 的強大功能與支援。----SQL 資料庫可在下列服務層級中取得。：基本、標準、Premium、Web （已停用）與商務用（已停用）。--標準是開始使用雲端設計商務應用程式的 [移至] 選項，可提供中型效能與業務連續性功能。 標準的效能目標-以可預測的每分鐘交易----頻率來提供更多相關資訊。如需有關 Azure SQL Database 的詳細資訊，請參閱 HTTP://go.microsoft.com/fwlink/p/?LinkId=306622。如需有關建立資料庫的詳細資訊，----參閱 HTTP://go.microsoft.com/fwlink/p/?LinkId=402063 [----= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = CREATECREATE DATABASE <Database_Name，sysname，Database_Name> （版本 = "<EDITION，" 標準> "，SERVICE_OBJECTIVE =" <SERVICE_OBJECTIVE，，S0> "），就會在 SQL Server 的下列累積更新中先修正問題。

狀態

Microsoft 已確認本篇文章＜適用於＞一節所列之 Microsoft 產品確實有上述問題。