Post reply

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

  • 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.

  • 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')

  • December 20, 2012 at 2:03 am

    #1570448

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

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply