Hi,

How can I tell if my MSSQL Server is running on a 32-bit or x64 platform?

Thanks,

Ned

Run the query "select @@version" and see which processor it was built for. The 2005 32-bit server I have access to indicates "Intel x86".

Thanks! Any idea what it would say if you were on an x64 system?

Also, I tried winver -- it came back mentioning 32, so I figured I had my answer. Thanks again.