How can I tell which version is installed?

One of the server admins recently installed SQL Server 2005 on a new Itamium server. I am trying to set the parameter on the services to indicate they are running on a 64 bit machine, however the changes are not taking...yes I'm stopping and restarting the services. I'm wondering if did not install the right version. Does anyone know how I can tell if the IA 64 version was installed

Answer this question

How can I tell which version is installed?

  • friend_friend

    I don't think you could install version other than ia64 on a Itanium machine.

    If you could start the server, try following sql, it should return a version string which indicate whether is x86/amd64/ia64.

    select @@version



  • Ramazan Acar

    Duh! It never occurred to me that it might list the processor. Thanks!

    Oh...I wish I had a brain!


  • How can I tell which version is installed?