CAT | SQL Server
Sep/10
6
How to know whether SQL Server is 32-bit or 64-bit
3 Comments · Posted by Ferry Meidianto in 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.
If it’s 64-bit then it will have (64-bit) added after the Edition name.