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

CAT | SQL Server

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

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