Full Server Name including Domain

• Cat-253986

  Ten Centuries

  Points: 1082

  More actions

  June 26, 2008 at 1:26 pm

  #70333

  I am trying to find which domain all my SQL Servers are on (they are currently on different domains). I am looking for a query to do this within SQL Server if possible to avoid having to connect to each one and go under computer properties and look at the full name.

  Any suggestions?

  ServerProperty with options Servername and Machinename only get me the basic server name, not including the domain.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  June 26, 2008 at 2:43 pm

  #834987

  I think you'd have to read this out of the registry.