What Now -- MSDE/SQL Server Version is OBSOLETE?

[NewsArchive]

Since Get System Info > MSDE/SQL Server Version is OBSOLETE, what is the
best means to determine if SQL Server 2005 Express or any other version
of SQL server is installed on a target machine?

Greg Fasolt

[NewsArchive]

> Since Get System Info > MSDE/SQL Server Version is OBSOLETE, what is the
> best means to determine if SQL Server 2005 Express or any other version
> of SQL server is installed on a target machine?

It depends on the version used. What you could try is you could query the
registry value to get the SQL version directly (similar to the following):

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\90\Tools\ClientSetup\CurrentVersion\Current Version

To see your instance name:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

SetupBuilder is Windows 7 installation -- "point. click. ship"

-- Official Comodo Code Signing and SSL Certificate Partner