64/32 bit SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

apw - 16 Jul 2008 15:01 GMT

Hi. I have a 64-bit server that I'm running SQL Server on but I'm not
sure if SQL Server is 64 bit or 32 bit. I read that the server would
have to be in a WOW mode to support 32 bit SQL Server. This is an
environment that I recently began working on. My question is, how can
I identify what version of SQL Server is running?

Thanks in advance.

Reply to this Message

Uri Dimant - 16 Jul 2008 15:10 GMT

apw
If I run
select @@version on the server I got

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

and on my workstation

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)

> Hi. I have a 64-bit server that I'm running SQL Server on but I'm not
> sure if SQL Server is 64 bit or 32 bit. I read that the server would
[quoted text clipped - 3 lines]
>
> Thanks in advance.

Reply to this Message