locked
64 bit or 32 bit RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Team,

     

    How can we find out it is 64 bit or 32 bit

    Is there any command is there ?

    Can any body know plz help me .

     

    Tx

    subu
    Friday, February 4, 2011 12:22 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    execute this:

    select @@version

     

    for 32-bit it will be x86,

    and x64 for 64-bit.

    Vishal Gajjar
    • Proposed as answer by GURSETHI Friday, February 4, 2011 1:03 PM
    • Marked as answer by Jonathan KehayiasMVP Saturday, February 5, 2011 2:47 AM
    Friday, February 4, 2011 12:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    To add on to what Vishal said, be sure you examine the database engine portion of @@VERSION rather than the OS version since you can run 32-bit under a 64-bit_OS.  Alternatively, you can use SERVERPROPERTY('Edition').  64-bit database engine editions will have "64-bit" appended.
    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    Friday, February 4, 2011 1:05 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    execute this:

    select @@version

     

    for 32-bit it will be x86,

    and x64 for 64-bit.

    Vishal Gajjar
    • Proposed as answer by GURSETHI Friday, February 4, 2011 1:03 PM
    • Marked as answer by Jonathan KehayiasMVP Saturday, February 5, 2011 2:47 AM
    Friday, February 4, 2011 12:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    To add on to what Vishal said, be sure you examine the database engine portion of @@VERSION rather than the OS version since you can run 32-bit under a 64-bit_OS.  Alternatively, you can use SERVERPROPERTY('Edition').  64-bit database engine editions will have "64-bit" appended.
    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    Friday, February 4, 2011 1:05 PM