Hi, I need to programatically check (during installation) if my SQL server is 32-bit (or processor architecture is x86) or 64-bit. SQL server can be 2005 or 2008. I am using C#. SQL query will also help.
When I do Select @@VERSION then I am getting this info: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
But I am not sure if this description is uniform across all the version of SQL server.