none
How to see is a installed version of SQL Server 2008 a 64-bit or 32-bit ?

Answers

  • Hi maestro z

    select @@version

    HTH

    Ewan

    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    Tuesday, October 06, 2009 9:30 AM
  • Try this , if it's 64 bit the output will be shown as 64 bit

    xp_msver 'FileDescription'

    Vidhya Sagar. Mark as Answer if it helps!
    Tuesday, October 06, 2009 11:39 AM
  • A futher option is to use:

    select serverproperty('edition')

    example output
    --------------------
    Standard Edition (64-bit)

    every day is a school day
    Tuesday, October 06, 2009 12:20 PM

All replies

  • Hi maestro z

    select @@version

    HTH

    Ewan

    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    Tuesday, October 06, 2009 9:30 AM
  • Try this , if it's 64 bit the output will be shown as 64 bit

    xp_msver 'FileDescription'

    Vidhya Sagar. Mark as Answer if it helps!
    Tuesday, October 06, 2009 11:39 AM
  • A futher option is to use:

    select serverproperty('edition')

    example output
    --------------------
    Standard Edition (64-bit)

    every day is a school day
    Tuesday, October 06, 2009 12:20 PM