How to determine 32 or 64 bit version of SQL Server

Run below query to know which edition SQL server is installed:


SELECT ServerProperty('edition')


It will show the result like this: 

32-bit: Enterprise Edition

OR

64-bit: Developer Edition (64-bit)

You can also check this with below code:

select @@version


It will show the result like this:


Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)   Apr  2 2010 15:53:02   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services on Windows NT 6.1 <X86> (Build 7600: )