SQL in Cloud

SQL Database: Query database edition and service objective through t-sql

SQL database v12 allows querying the database edition and service objective through t-sql using databasepropertyex. One has to connect to the database to get the edition / serviceobjective of that database. This query won’t return the results if run on the master database. Here are the results for a standard, S0 database

Syntax:

select DATABASEPROPERTYEX(db_name(),’serviceobjective’)
select DATABASEPROPERTYEX(db_name(),’serviceobjectiveid’)
select DATABASEPROPERTYEX(db_name(),’edition’)

Returns:

S0
f1173c43-91bd-4aaa-973c-54e79e15235b
Standard

 

« Why SQL Azure?
Row versioning in SQL Database V12 »

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

Pages

  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline

Archives

  • May 2016
  • December 2015
  • July 2015
  • May 2015
  • April 2015

Categories

  • SQL Azure (8)
  • Uncategorized (3)

WordPress

  • Log in
  • WordPress

Subscribe

  • Entries (RSS)
  • Comments (RSS)
  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline