Technical FAQs

Ask a Question

How to Identify if SQL Server is 32 or 64 bit

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) 

 
Was this helpful?
What can we do to improve the information ?