Sunday, February 19, 2012

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?

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

|||

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

Oh...I wish I had a brain!

No comments:

Post a Comment