Find Domain Name from Synapse database

Question

Hi, 

Is there any way to find the Fully Qualified Domain Name from Synapse database through a query similar to the one on SQL Server   :   SELECT DEFAULT_DOMAIN()[DomainName]

<time datetime="2014-04-30T20:07:15" itemprop="dateCreated" style="margin:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;line-height:inherit;font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;vertical-align:baseline;box-sizing:inherit;color:#242729;"></time>

Answer 1

Hi deepu229,

Note: You can find Domain Name using T-SQL and this is available only for SQL Server and Azure SQL Database. And the same don’t applies to Azure Synapse Analytics.

In T-SQL, you would use this to query the Domain Name of the SQL Server:

SELECT DEFAULT_DOMAIN()[DomainName]

For more details, refer “DOMAINS(Transact-SQL)”.

For Azure Synapse Analytics (formerly SQL DW):

The server name in the following example is samplesvr.database.windows.net. To find the fully qualified server name:

1. Go to the Azure portal.
2. Click on Azure Synapse Analytics.
3. Click on the Azure Synapse Analytics you want to connect to.
4. Locate the full server name.

Hope this helps. Do let us know if you any further queries.

----------------------------------------------------------------------------------------

Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

Answer 2

Hello,

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.

Answer 3

Hello,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.