KB3007905 - Update to the template script for creating SQL Azure databases in SQL Server Management Studio 2014
SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 StandardMore...Less
Assume that you use Microsoft SQL Server Management Studio 2014 (SSMS 2014) to connect to Microsoft SQL Azure Databases. In Management Studio, when you right-click Databases, and then click the New Database command, the template script is as follows:
-- ====================================================================== -- 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
The script does not include SQL Azure-specific options such as EDITION and SERVICE_OBJECTIVE.
After you apply this hotfix, the template script is as follows:
========================================================================================================= -- Create database template for Azure SQL Database -- -- This script will only run 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. -- -- SQL Database is a relational database-as-a-service that makes tier-1 capabilities easily accessible -- for cloud architects and developers by delivering predictable performance, scalability, business -- continuity, data protection and security, and near-zero administration — all backed by the power -- and reach of Microsoft Azure. -- -- SQL Database is available in the following service tiers: Basic, Standard, Premium , Web (Retired) -- and Business (Retired). -- Standard is the go-to option for getting started with cloud-designed business applications and -- offers mid-level performance and business continuity features. Performance objectives for Standard -- deliver predictable per minute transaction rates. -- -- See http://go.microsoft.com/fwlink/p/?LinkId=306622 for more information about Azure SQL Database. -- -- See http://go.microsoft.com/fwlink/p/?LinkId=402063 for more information about CREATE DATABASE. -- -- ==========================================================================================================CREATE
CREATE DATABASE <Database_Name, sysname, Database_Name> ( EDITION = '<EDITION, , Standard>', SERVICE_OBJECTIVE='<SERVICE_OBJECTIVE,,S0>' ) GO The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 4 for SQL Server 2014 /en-us/help/2999197
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: