How should a T-SQL script detect if it's running in Azure SQL Database or on-premise? [duplicate]

Question

Suppose I have a piece of T-SQL that gets variously run both on Azure SQL Database and on-premise SQL Server. How can I programmatically detect, within the script itself, which of these is the prevailing context?

I note that

SELECT @@VERSION

on Azure SQL Database yields a string that starts

Microsoft SQL Azure

but parsing the output of @@VERSION doesn't make for a nice feeling, and of course the specifics could change at any time.

Is there a more-obviously-correct way of doing this?

Edwin van der V · Accepted Answer · 2018-01-25 16:45:55Z

9

SELECT SERVERPROPERTY ('edition')

Can also check it, when its not SQL Azure you know its on prem.

answered Jan 25, 2018 at 16:45

Edwin van der V

2382 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How should a T-SQL script detect if it's running in Azure SQL Database or on-premise? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related