Post reply

How to tell if MSDE or Full edition other than @@VERSION

  • December 17, 2004 at 4:25 am

    #163453

    Hi

    I need a way to tell if an MSDE edition is installed or wheter it is a full edition, other than using @@VERSION ot SELECT SERVERPROPERTY ('edition')

    I need to be able to do it by looking at files installed, or file versions or registry entries.

    The reason I need to be able to do this is for my Installshield installation, so if MSDE is installed I can install another instance, but not if a 'full' edition is installed.

    Hope this makes sense, any help appreciated.

    James

  • December 17, 2004 at 12:34 pm

    #534359

    xp_msver is a system procedure that should tell you the fileversion.

  • December 17, 2004 at 4:33 pm

    #534391

    Thanks for the reply, but not quite what I was looking for I don't think. I need to be able to tell if msde is installed without having to connect to server and run any T-SQL statment, or Query.

    I need to be able to do it by looking at files installed or versions of files or registry entries that would distinguish an MSDE version from any other full version.

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

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