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.

image

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

image

3 thoughts on “How to know whether SQL Server is 32-bit or 64-bit

  1. Pingback: Check if the MSSQL Server is 32-bit or 64-bit | Eureka!

Leave a Reply

Your email address will not be published. Required fields are marked *