How can you detect on runtime if your sql-server 2005 instance is a 32 or 64 bit instance?

Question

How can you detect if your sql-server 2005 instance is a 32 or 64 bit instance from C# code? If you know some documentation on this issue, please let me know.. Thanks!

Answer 1

I'm curious... why?

Answer 2

Use SERVERPROPERTY ( propertyname )

With property name Edition.

64-bit versions of the Database Engine append (64-bit) to the version.

SELECT SERVERPROPERTY ( 'Edition' )

For me on my x64 machine returns the following string value: Enterprise Edition (64-bit)

You could also check the env variable PROCESSOR_ARCHITECTURE to see what the machine itself is running as.