Azure DB properties - Find what is the Azure database edition using a query

PROBLEM:

You want to find what is the Azure database edition using a query

SOLUTION:

The following query returns the current setting of the specified database option or property. Change the first parameter "database_name" to your Azure database name, connect to it and run the query

SELECT

DATABASEPROPERTYEX ('database_name','Collation') AS Collation,

DATABASEPROPERTYEX ('database_name','ComparisonStyle') AS ComparisonStyle,

DATABASEPROPERTYEX ('database_name','Edition') AS Edition,

DATABASEPROPERTYEX ('database_name','LCID') AS LCID,

DATABASEPROPERTYEX ('database_name','MaxSizeInByte') AS MaxSizeInBytes,

DATABASEPROPERTYEX ('database_name','Recovery') AS Recovery,

DATABASEPROPERTYEX ('database_name','SQLSortOrder') AS SQLSortOrder,

DATABASEPROPERTYEX ('database_name','Status') AS Status,

DATABASEPROPERTYEX ('database_name','Updateability') AS Updateability,

DATABASEPROPERTYEX ('database_name','UserAccess') AS UserAccess,

DATABASEPROPERTYEX ('database_name','Version') AS Version,

DATABASEPROPERTYEX ('database_name','IsAnsiNullsEnabled') AS IsAnsiNullsEnabled,

DATABASEPROPERTYEX ('database_name','IsAnsiNullDefault') AS IsAnsiNullDefault,

DATABASEPROPERTYEX ('database_name','IsAnsiPaddingEnabled') AS IsAnsiPaddingEnabled,

DATABASEPROPERTYEX ('database_name','IsAnsiWarningsEnabled') AS IsAnsiWarningsEnabled,

DATABASEPROPERTYEX ('database_name','IsArithmeticAbortEnabled') AS IsArithmeticAbortEnabled,

DATABASEPROPERTYEX ('database_name','IsAutoClose') AS IsAutoClose,

DATABASEPROPERTYEX ('database_name','IsAutoCreateStatistics') AS IsAutoCreateStatistics,

DATABASEPROPERTYEX ('database_name','IsAutoShrink') AS IsAutoShrink,

DATABASEPROPERTYEX ('database_name','IsAutoUpdateStatistics') AS IsAutoUpdateStatistics,

DATABASEPROPERTYEX ('database_name','IsCloseCursorsOnCommitEnabled') AS IsCloseCursorsOnCommitEnabled,

DATABASEPROPERTYEX ('database_name','IsInStandBy') AS IsInStandBy,

DATABASEPROPERTYEX ('database_name','IsLocalCursorsDefault') AS IsLocalCursorsDefault,

DATABASEPROPERTYEX ('database_name','IsMergePublished') AS IsMergePublished,

DATABASEPROPERTYEX ('database_name','IsNullConcat') AS IsNullConcat,

DATABASEPROPERTYEX ('database_name','IsNumericRoundAbortEnabled') AS IsNumericRoundAbortEnabled,

DATABASEPROPERTYEX ('database_name','IsParameterizationForced') AS IsParameterizationForced,

DATABASEPROPERTYEX ('database_name','IsQuotedIdentifiersEnabled') AS IsQuotedIdentifiersEnabled,

DATABASEPROPERTYEX ('database_name','IsPublished') AS IsPublished,

DATABASEPROPERTYEX ('database_name','IsRecursiveTriggersEnabled') AS IsRecursiveTriggersEnabled,

DATABASEPROPERTYEX ('database_name','IsSubscribed') AS IsSubscribed,

DATABASEPROPERTYEX ('database_name','IsSyncWithBackup') AS IsSyncWithBackup,

DATABASEPROPERTYEX ('database_name','IsTornPageDetectionEnabled') AS IsTornPageDetectionEnabled;

See: http://msdn.microsoft.com/en-us/library/windowsazure/ee621786.aspx

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!