Post reply

Detect 32 or 64 bit SQL from registry.

  • February 27, 2013 at 1:51 pm

    #274582

    I am trying to write up a script to detect whether the installed SQL Server 2008 instance is 32 or 64 bit.

    Here's the catch - SQL Server would be disabled when I run this scirpt. So I cant use xp_msver or @@version to get the info.

    Is there any way to get the same info from the registry?

    Thanks,

    Akshay.

  • February 27, 2013 at 8:59 pm

    #1591838

    have you tried this?

    It was my first Google result

    http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/8d6b5603-e030-4c6d-9872-afe4741a7d16/

  • February 27, 2013 at 9:22 pm

    #1591846

    Yes, I have tried it. But I couldn't find any registry entry that clearly states whether the SQL Server instance is 32 bit or 64 bit.

  • February 27, 2013 at 9:35 pm

    This was removed by the editor as SPAM

  • February 28, 2013 at 2:37 am

    #1591909

    Maybe you can check if sqlservr.exe is installed in Program Files or in "Program Files (x86)". (assuming the server itself is 64-bit)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 28, 2013 at 3:16 am

    #1591914

    akshay.pawar123 (2/27/2013)

    I am trying to write up a script to detect whether the installed SQL Server 2008 instance is 32 or 64 bit.

    Here's the catch - SQL Server would be disabled when I run this scirpt. So I cant use xp_msver or @@version to get the info.

    Is there any way to get the same info from the registry?

    Thanks,

    Akshay.

    Why can't you just retrieve and store this info when the instance is online????

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

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

Viewing 6 posts - 1 through 5 (of 5 total)

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