Post reply

How to find ALL SQL servers and their edition

  • November 8, 2011 at 10:13 pm

    #390806

    I need a method in which I can "find" all Windows servers running SQL Server Enterprise or Standard. I need to know which server is running which edition of SQL.

    Is there an automated way of doing this?

  • November 8, 2011 at 10:45 pm

    #1404957

    Personally I would use powershell.

    @AllenWhite did a greate article [/url]a few years back.

    Other options would be to use SQLPing (not on my work laptop so can not verify you get the Edition).

  • November 8, 2011 at 10:46 pm

    #1404958

    Hi

    Think you need a third party software to do this,...

    But if want to know by using some steps you can find the SQL server and its edition.

    execute flowing.

    select @@version -but you have to first connect SQL Serverone by one.

    to find Installed SQL server: go to SQL server configuration manager--> Sql server services. Right click SQL instance select properties-->Advance --see under: Stock keeping Unit Name:

    Ali
    MCTS SQL Server2k8

  • November 8, 2011 at 10:49 pm

    #1404959

    USE THIS COMMAND

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

  • November 8, 2011 at 10:57 pm

    #1404961

    You can find same thing in one line, by using only

    select @@version

    Ali
    MCTS SQL Server2k8

  • November 9, 2011 at 12:23 am

    #1404987

    Julian Milano-440574 (11/8/2011)

    I need a method in which I can "find" all Windows servers running SQL Server Enterprise or Standard. I need to know which server is running which edition of SQL.

    Is there an automated way of doing this?

    You should give a try to Central Management Servers.

    In SQL Server 2008, you can designate an instance of SQL Server as a central management server. Central management servers store a list of instances of SQL Server that is organized into one or more central management server groups. Actions that are taken by using a central management server group act on all servers in the server group. This includes connecting to servers by using Object Explorer and executing Transact-SQL statements and Policy-Based Management policies on multiple servers at the same time. Versions of SQL Server that are earlier than SQL Server 2008 cannot be designated as a central management server.

    Administering Multiple Servers Using Central Management Servers

    http://msdn.microsoft.com/en-us/library/bb895144.aspx

  • November 9, 2011 at 1:51 am

    #1405023

    Have a look at MAP (Microsoft assessment and planning toolkit). Free download that will find all sorts of things about what's running on your network.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

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