How to determine if SQL Server and O/S are 32-Bit or 64-Bit?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738347

  More actions

  July 23, 2009 at 9:28 am

  #1029063

  Interesting thread, and some good info.

  Here's the weird one. What if you have a 32bit VM on a 64bit host. do you want to know the host platform? I'm curious if this ever matters. I don't think so, but I wonder if I'm overlooking something.

• arsal.2004.1

  Valued Member

  Points: 57

  More actions

  January 10, 2011 at 6:48 am

  #1271356

  You can determine what version of OS you are running by looking at

  Start > Programs > Accessories > System Tools > System Information

  [Note: I am running windows server 2008 R2 & it works for me]

  also, for sql server, this works for me select serverproperty('edition')

• daftmoo

  SSC Rookie

  Points: 46

  More actions

  December 20, 2012 at 2:03 am

  #1570448

  Task manager, in the description for SQL Server gives the bit version