Post reply

SQL Server Type Identification

  • July 15, 2004 at 6:17 am

    #84969

    Hi all

    I am certainly not a SQL guru, and would appreciate some assistance. On my network there are a host of different versions of SQL server

    1.2000 Enterprise

    2.2000 Standard

    3.2000 Personal

    4.2000 Developer

    5.MSDE

    6.Just connectivity tools

    I run SMS 2003 and would like an easy way to identify which version of SQL the client is running. Possibly a file / date size to look for ??? Not sure.

    Thanks in Advance

    Wade

     

  • July 16, 2004 at 6:31 am

    #514819

    Wade,

    You can do a 'SELECT @@VERSION' from Query Analyzer (or)

    Goto Enterprise Manager right click on your instance, choose properties and under product you will

    see the product version of SQL Server  

  • July 16, 2004 at 10:50 am

    #514904

    Of course, you are not going to be able to run @@version from SMS.  I dug out how to do this once, but it was quite awhile ago, do not remember exactly, and cannot find the old code.

    But I do remember checking the registry, and using something like ProductID or ProductCode under HKLM\Software\Microsoft\Microsoft SQL Server. 

    However, there was a catch to it.  You have to look at InstalledInstances to see if multiple instances have been installed (and they can be of different editions, versions, and service pack or patch levels).  If the first instance listed is MSSQLSERVER, it will be the default instance, and its settings are in HKLM\Software\Microsoft\MSSQLSERVER.  Other instances will be under HKLM\Software\Microsoft\Microsoft SQL Server\<instance name>\MSSQLSERVER.

    Hope this helps, and you can carry it from here.



    Mark

Viewing 3 posts - 1 through 2 (of 2 total)

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