KB3007905 - Update to the template script for creating SQL Azure databases in SQL Server Management Studio 2014

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Standard

Symptoms


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.

Resolution


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

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.