How to find edition (32 bit or 64 bit)

• ram4tech

  Hall of Fame

  Points: 3140

  More actions

  August 28, 2007 at 9:50 am

  #69946

  Hi,

  How do I find which edition of SQL Server is running on a box?

  select serverproperty('Edition') gives if it is EE or SE, etc.

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  August 28, 2007 at 10:20 am

  #729836

  Try select @@version it details (x64) 64 bit or (x86) 32 bit

• ram4tech

  Hall of Fame

  Points: 3140

  More actions

  August 28, 2007 at 10:26 am

  #729839

  Thank you.