Post reply

SQL 2005 32 or 64 bit

  • July 28, 2009 at 2:33 pm

    #203252

    I would like to know whether the SQL 2005 installed on the server is a 32 or 64 bit. I have looked at the summary.txt file under program files\sql server 2005\... and that document doesn't mention any of that. Thanks for your help

  • July 28, 2009 at 3:01 pm

    #1031337

    I believe you can try:

    SELECT SERVERPROPERTY ('edition') as [Product Edition]

    64 Bit should say Standard Edition (64 Bit)/Enterprise Edition (64 Bit) in the text, 32 bit will just say Standard Edition or Enterprise Edition

    Can someone please correct me if I'm wrong..

    Thanks

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

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • July 28, 2009 at 4:01 pm

    #1031380

    torpkev (7/28/2009)

    I believe you can try:

    SELECT SERVERPROPERTY ('edition') as [Product Edition]

    64 Bit should say Standard Edition (64 Bit)/Enterprise Edition (64 Bit) in the text, 32 bit will just say Standard Edition or Enterprise Edition

    Can someone please correct me if I'm wrong..

    Thanks

    True.

  • July 29, 2009 at 6:39 am

    #1031608

    Thanks guys, this answered my question.

  • July 30, 2009 at 10:56 am

    #1032538

    hmmm.. I prefer select @@version

    gives you everything - all the service pack, build and edition info as well as microsofts dinky little copyright messages.

    🙂

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

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