{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
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)

Schneider Electric UK

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.