Query SQL version across estate

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  November 1, 2012 at 7:42 am

  #269453

  Hi - I am wanting to query the SERVERPROPERTY of all out SQL servers and put the information in a table such that I can write a report against it.

  What is the best way to query SERVERPROPERTY for a list of servers if doing this as a SQL job?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  November 1, 2012 at 10:21 am

  #1555102

  powershell.

  http://ask.sqlservercentral.com/questions/1568/execute-a-query-against-multiple-servers.html