Monday, July 23, 2012

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
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: ) 

No comments:

Post a Comment