Is it possible to get Azure database region is sql script?

Question

In Azure database, ServerProperty can get some server property information. But, I want to know the region which database server is running. Is it possible? Can I get this region information with SQL script like below (or something like this):

SELECT SERVERPROPERTY('Region')

Yogi · Accepted Answer · 2020-02-25 05:36:54Z

0

Not sure if this can be done from Sql out of the box, but one indirect way could be by using powershell and then calling that powershell script from sql script.

Get-AzureRmSqlServer powershell cmdlet gives detailed information about the servers including region. (Ref)

Then you can call this PS script from SQL as described here.

Not tried it but hope it should work.

answered Feb 25, 2020 at 5:36

Yogi

9,8693 gold badges49 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

Is it possible to get Azure database region is sql script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related