Folks,
As like my previous post, I have to find whether the MSSQL server installed in a machine is a 32bit version or 64 bit version. This is possible with a simple following query .
The output will show the Edition name alone for 32 bit. For 64 bit, the Edition name have 64-bit string appended to it.
Sample output :
For 32 bit : Enterprise Edition
For 64 bit : Enterprise Edition(64-bit)
As like my previous post, I have to find whether the MSSQL server installed in a machine is a 32bit version or 64 bit version. This is possible with a simple following query .
select SERVERPROPERTY(‘edition’)
The output will show the Edition name alone for 32 bit. For 64 bit, the Edition name have 64-bit string appended to it.
Sample output :
For 32 bit : Enterprise Edition
For 64 bit : Enterprise Edition(64-bit)
