MASTER YOUR CASTLE with your new build or reno project
Enter competition

How to Identify if SQL Server is 32 or 64 bit

FA209388

24/01/2018

Environment:
SQL Server version identification

Resolution:

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* 



Connect to a SQL instance in Management Studio, and select New Query



Copy and paste the following query into the query editing window
 
--- Execute Against the Master Database
SELECT CASE WHEN CHARINDEX('64', CAST(SERVERPROPERTY('Edition') AS
VARCHAR(100))) > 0
THEN 64
ELSE 32
END;

 
Verify that the MASTER database is selected and Click Execute



The Results window will display 32 or 64, indicating either a 32 or 64 bit system, respectively.



Alternatively you can execute the following query to return the complete SQL version and build.

select @@version

Example output: 
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)   Jun 11 2012 16:41:53   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)