details of all servers

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  August 26, 2010 at 1:35 am

  #141699

  this is my requirement

  i want to generate a report of all server details (edition , Sp and version) where we have nearly 100 servers in our environment.

  How can i acheive this .

• Stupeo

  Hall of Fame

  Points: 3067

  More actions

  August 26, 2010 at 3:48 am

  #1212178

  So you want to search the network for all SQL Server instances and return the name and version details?

  If so, you could try SQL Ping:

  http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

  Matt.