How to find whether Sql Server 2005 x86 is installed or x64 is installed?
Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can mention so.
But how about a new DBA started and need to perform a set of actions on X64 editions and with no documentation available!
SELECT @@VERSION
or
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
This will display the results and will give you the information. Also another way to find by referring to the registry keys that are listed below:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup\Edition
Further refer to this SQLCLR method to obtain registry information.