I think this is an easy one...

If I have a 64 bit version of SQL 2005 installed, will "select @.@.version" indicate it is a 64 bit version? If not, how do I determine such? Thanks in advance.

Yes.

Code Snippet

Select @.@.version

On x64 Returns:

Code Snippet

Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

On x86:

Code Snippet

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

|||Excellent Sir! Thank you very much.