How to know whether SQL Server is 32-bit or 64-bit

Simple way to know whether SQL Server is 32-bit or 64-bit is by executing the following script:

select SERVERPROPERTY(‘edition’)

It will then return the Edition of SQL Server installed. If it’s 32-bit it will just return the Edition name.

If it’s 64-bit then it will have (64-bit) added after the Edition name.

Posted

September 6, 2010

Ferry Meidianto

Tags:

Comments

Check if the MSSQL Server is 32-bit or 64-bit | Eureka!

October 11, 2013

[…] Ferry Meidianto – How to know whether SQL Server is 32-bit or 64-bit Pin ItMorePrintEmailDiggShare on TumblrPocketGoogle+ Ying Kit YuenLike this:Like Loading… This entry was posted in Database and tagged MSSQL, SQL Server on October 11, 2013 by Ying Kit Yuen. […]
J

May 15, 2014

Thanks! Worked perfectly.
Chris

September 2, 2014

Thanks! it worked.