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?

  • No 'select @@version' does not explicitly display 32 or 64-bit. I have tried the following sql commands and neither supply what I am looking for.

    --Version Number

    select @@version

    --Service Pack

    select serverproperty('ProductLevel')

    --Version Number

    select serverproperty('ProductVersion')

    --Edition

    select serverproperty('Edition')

    Thanks, Kevin