How to know if SQL Server is in the cloud or on pr

2019-06-14 16:47发布

问题:

I recently joined in new job, they are using Azure SQL Server. Initially I don't know that SQL Server is in Azure. I am wondering how can I know whether SQL Server is in Azure or on premises?

回答1:

Execute the query:

SELECT @@VERSION

The result will tell you if you are using Azure SQL Database or any other version/edition

** If you are talking about SQL Server on Virtual machine in the azure, then this is the same as local version/edition