Find Domain Name from Synapse database RRS feed

  • 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>
    Thursday, March 19, 2020 8:32 PM

All replies

  • 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:


    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.

    Monday, March 23, 2020 9:16 AM
  • 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.

    Tuesday, March 24, 2020 10:09 AM
  • Hello,

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

    Thursday, March 26, 2020 9:26 AM