how to determine SQL version?
hey all,
how can I determine the SQL server version by NSIS
I want to know before the installer start it is SQL2000 or 2005?
Archive: how to determine SQL version?
how to determine SQL version?
hey all,
how can I determine the SQL server version by NSIS
I want to know before the installer start it is SQL2000 or 2005?
These explain techniques for getting version via sql commands:
http://support.microsoft.com/default.aspx/kb/321185
http://sqlserver2000.databases.aspfa...m-running.html
And this is soemthing to get you started on running sql scripts from NSIS:
http://nsis.sourceforge.net/Execute_SQL_Server_scripts
Glancing at my registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
I see a version key for every version of SQL Server I have installed. You could maybe check for each key and then verify that the instance name exists.
The difficult thing is that you can have many different versions of SQL Server all running on a system at one time. So you will need to ask yourself, in the event there is more than one, do I want to know what the greatest version is, the least, or all versions. It depends on what you plan to do with that information.
Or..........you can use my wonderful plugin WmiInspector ;)
WmiInspector plug-in