RE: List sql servers, versions, SP installed in all the servers of environment.

SSC Guru

Points: 323504

February 13, 2013 at 7:22 am

I'd go with the powershell as well, but here's one more alternative:

I've used SQLRecon in the past, which is free and did the job for me, but was last created in 2005;

http://www.specialopssecurity.com/labs/sqlrecon/

I just ran it on my network again with default settings, and noticed it did not find any of my local instances like \SQL2005 and \SQL2012 , only my default instance, which is running 2008R2.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!