principleMinor
T-SQL to show Azure SQL Managed Instance vs Azure SQL Database
Viewed 0 times
managedshowsqldatabaseinstanceazure
Problem
Restated: How can I use T-SQL to determine whether a instance is an Azure SQL Managed Instance or Azure SQL Database?
Solution
To programmatically determine the engine edition, use SELECT
SERVERPROPERTY('EngineEdition'). This query will return '5' for single
databases/elastic pools and '8' for managed instances in Azure SQL
Database.
https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-2017
SERVERPROPERTY('EngineEdition'). This query will return '5' for single
databases/elastic pools and '8' for managed instances in Azure SQL
Database.
https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-2017
Context
StackExchange Database Administrators Q#234497, answer score: 4
Revisions (0)
No revisions yet.