Post reply

How to know whether the sqlserver is 32 bit or 64 bit

  • February 17, 2009 at 3:31 am

    #127839

    Hi All. Could any one please tell me how do i know whether the installed sqlserver2005 is 32bit or 64bit? And can 64bit sqlserver2005 be installed in a 32 bit O.S.

  • February 17, 2009 at 3:44 am

    #945042

    After executing Exec XP_MSver you will get 20 rows in result

    Checkbelow X86 that means it is 32 bit or if it show X64 then it is 64 bit.

    PlatformNT INTEL X86

    Comments NT INTEL X86

  • February 17, 2009 at 4:15 am

    #945064

    Thanks sir. Actually (Intel X86) comes using @@version also but i was not knowing that it means 32bit thanks a lot.

  • February 17, 2009 at 9:52 am

    #945292

    select serverproperty('edition')

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 18, 2009 at 2:07 am

    #945729

    Perry Whittle (2/17/2009)

    select serverproperty('edition')

    'edition' only seems to return eg "Enterprise Edition", nothing about processor. Though I don't have 64-bit to see if that's any different.

  • February 18, 2009 at 2:28 am

    #945738

    Please tell me can i install 64 bit SQLserver2005 on 32 bit operating system

  • February 18, 2009 at 2:29 am

    #945740

    No Ritesh it is not possible. Vice-Versa is possible!

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • February 18, 2009 at 2:38 am

    #945741

    Ewan Hampson (2/18/2009)

    Perry Whittle (2/17/2009)

    select serverproperty('edition')

    'edition' only seems to return eg "Enterprise Edition", nothing about processor. Though I don't have 64-bit to see if that's any different.

    run it on a 64bit machine 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 6, 2011 at 6:49 am

    #1270052

    u can find it in Control panel add/remove program files

  • January 6, 2011 at 7:29 am

    #1270081

    You do realise that this thread is nearly a year old 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply