Ferry Meidianto | /* Living in .NET World */

Sep/10

6

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 comments

  • Check if the MSSQL Server is 32-bit or 64-bit | Eureka! · October 11, 2013 at 11:00 am

    […] 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 at 11:18 pm

    Thanks! Worked perfectly.

  • Chris · September 2, 2014 at 11:21 pm

    Thanks! it worked.

Leave a Reply

<<

>>

Theme Design by devolux.nh2.me

Disclaimer

All postings/content on this blog are provided "AS IS" with no warranties, and confer no rights. All entries in this blog are my opinion and don't necessarily reflect the opinion of my employer or sponsors. The content on this site is licensed under a Creative Commons Attribution By license.
To top