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?

  • July 21, 2009 at 2:23 pm

    #1027916

    select @@version works for the 64-bit sql edition but i am not sure how to get the OS.

    output from select @@version on 64-bit machine.

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)