症状
假设你使用 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。
解决方案
应用此修补程序后,模板脚本如下所示: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =---- 若要在 SQL Server Management Studio 中管理此数据库,请连接到创建的数据库或连接到 master。----SQL 数据库是一种关系数据库的服务,它通过提供可预测的性能、可伸缩性、业务-连续性、数据保护和安全以及接近零的管理(由 Microsoft Azure 的强大功能和访问权限)来使第1层功能易于访问。在以下服务层中提供了----SQL 数据库的支持:基本、标准、高级、Web (已停用)和企业版(已停用)。-标准是开始使用云设计的业务应用程序的 "转到" 选项,提供了中等级别的性能和业务连续性功能。 标准性能目标-以可预测的每分钟事务费率提供。----有关 Azure SQL 数据库的详细信息,请参阅 http://go.microsoft.com/fwlink/p/?LinkId=306622。----有关创建数据库的详细信息,请参阅 http://go.microsoft.com/fwlink/p/?LinkId=402063。----= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = CREATECREATE <Database_Name,sysname,Database_Name> (EDITION = "<EDITION,,标准>",SERVICE_OBJECTIVE = "<SERVICE_OBJECTIVE,,S0>")在 SQL Server 的以下累积更新中首先修复该问题。
SQL Server 2014 的累积更新4 /en-us/help/2999197
SQL Server 的每个新的累积更新均包含以前的累积更新中包含的所有修补程序和所有安全修补程序。 查看 SQL Server 的最新累积更新:
状态
Microsoft 已确认这是在“适用范围”部分中列出的 Microsoft 产品存在的问题。