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?

  • Here is the only difference I have found to tell for sure. On 64-bit sql instances this returns 2 rows

    name

    affinity64 mask

    affinity64 I/O mask

    SELECT [name] FROM sys.configurations

    WHERE NAME LIKE '%64%'

    on 32-bit instances it returns 0 rows.

    Still working on the OS version