Home Forums SQL Server 2005 Administering How to determine if SQL Server and O/S are 32-Bit or 64-Bit? RE: How to determine if SQL Server and O/S are 32-Bit or 64-Bit?

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