How can I check the version and edition of SQL Server installed?

orange

When you need to perform an audit of SQL Server installations (by edition) across a huge number of servers, this script should save you a whole lot of time.

To start with, get a list of servers into a .txt file – one server name per line.  In my example, here’s a sample of what c:\temp\servers.txt looks like:

sqledition1

 

With that sorted, assuming your servers are online and not being blocked by the Windows Firewall, run the below script, and your output should appear as c:\temp\sqlversioncheck.csv

 

 

All things being equal, you should get something like this:

sqledition2

 

And here’s a handy chart for converting those version numbers into something more meaningful: http://sqlserverbuilds.blogspot.com.au/

orange

2 Comments How can I check the version and edition of SQL Server installed?

  1. vegas4

    Make sure there is no space after the computer name in “servers.txt”, that will result in a failure to test the connection to the host (ask me how I know…)

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *