How to check SQL Server editions

Question

How to check SQL Server editions

Jeetendra

SSCrazy

Points: 2076
More actions
January 27, 2009 at 2:46 am

#125950

Hi Gurus,
I wanna know a way to check the SQL Server Versions on all the servers (3000+) in the organisation.
Dont wanna Login to each of the server and run the @@version or Serverproperty command.
Is there any other way ...???
Please Help...!!!!!!!
Kindest Regards,
Jeetendra

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

iainthepitman SSCommitted Points: 1666 More actions · Answer 1

do you have a list of the 3000+ servers? you could create an SSIS package that connects to each server and runs a query which populates a table in a database on a central server.

Jeetendra SSCrazy Points: 2076 More actions · Answer 2

I have the different domains in which this servers are located but i can get the list...

Can u send me the details of the SSIS Package...

Is there any other way ....

Kindest Regards,

Jeetendra

CrazyMan SSChampion Points: 12560 More actions · Answer 3

have u got a list of server Instance name, if so load them on a table and run ur command across all the servers from a SP 🙂

Hope this helps

Andy Hogg SSCarpal Tunnel Points: 4585 More actions · Answer 4

Idera's "SQL Admin Toolset" comes with a tool called "Multi Query" that allows you to run the same SQL query against any number of named instances.

Come to think of it, there is also a tool called "Patch Analyser" within that same product which will give the version information of all the servers within your estate.

I believe you can download a time-limited trial of the product from Idera's website.

ravikanth. Hall of Fame Points: 3472 More actions · Answer 5

you can use "Microsoft Assessment and Planning Toolkit" , free tool from microsoft.

the tool scans the computers based on a file with list of computer names or a range of IP's or across a domain.

Jeetendra SSCrazy Points: 2076 More actions · Answer 6

Hi Ravikanth,

Thats what I exactly require...

But My question i still remains which file contains the information about the SQL Server editions and versions...

Kindest Regards,

Jeetendra

liebesiech SSCrazy Points: 2610 More actions · Answer 7

Hi

The command select @@version in the query window returns this:

Microsoft SQL Server 2005 - 9.00.3282.00 (Intel X86) Aug 5 2008 01:01:05 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

or even better if you like it more structured:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') returns 3 columns containing this:

9.00.3282.00SP2Standard Edition

Check this Microsoft KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Hope this is of help.

Venu Gunti SSC Eights! Points: 883 More actions · Answer 8

Venu Gunti

SSC Eights!

Points: 883

January 29, 2009 at 1:12 am

#934436

Idera's multi query suggestion is good option.

-:)

Sentil Kumar SSC Enthusiast Points: 122 More actions · Answer 9

Hi ,

This will help you........................

SELECT

SERVERPROPERTY('productversion') AS Version,

SERVERPROPERTY ('productlevel') AS ProductInfo,

SERVERPROPERTY ('edition') AS Edition

[font="Arial"][font="Verdana"][/font][/font]
With Regards
Sentil Kumar

"Give god first place in your heart
He will take you to places that you have never dreamed off"