Post reply

How to determine 32 bit and 64 bit SQl Server instance progrmatically?

  • October 22, 2007 at 10:15 am

    #199337

    Hello all,

    Is there a system stored procedure that I can execute to determine whether the SQL Server instance is a 32 bit or 64 bit?.

    Please help!

    Thanks,

    Ganesh

  • October 22, 2007 at 10:30 am

    #744173

    Hi,

    I think you can try either "select @@version()" or "xp_msver"....

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • October 22, 2007 at 10:32 am

    #744174

    select @@version

    Would return

    Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

    You can search the results for X64, if you're looking to poll your installs.


    John Zacharkan

  • October 22, 2007 at 10:40 am

    #744176

    Hello,

    Thanks for the reply. I guess you are suggesting to look for the "x64" string in the @@version results. Is there a better way other than this to determine that the instance is 64 bit?. I am not that comfortable in performing a string check to determine the version.

    Thanks,

    Ganesh

Viewing 4 posts - 1 through 3 (of 3 total)

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