Can 32 bit SQL 2005 run on a 64 bit processor?

I'm going to be buying a new home PC, and am realizing that many of them now
come in 64 bit. I will of course want to install SQL 2005, but my copy is 32
bit. Also, my copy of Windows XP Pro is 32 bit as well. Should these things
be OK on a 64 bit box?
SQL Server depends on the OS architecture. So, if you are running as 32-bit
OS then the 32-bit version of SQL Server is just fine. Even if you upgrade
your OS to 64-bit you can still use the 32-bit version of SQL Server using
Windows-on-Windows. Also, XP Pro 32-bit will work fine on 64-bit processors.
However, the 32-bit OS cannot take advantage of the 64-bit hardware so you
might look into upgrading to XP 64-bit.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"ChrisR" <ChrisR@.NoEmail.com> wrote in message
news:epmRRSrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
> I'm going to be buying a new home PC, and am realizing that many of them
> now come in 64 bit. I will of course want to install SQL 2005, but my copy
> is 32 bit. Also, my copy of Windows XP Pro is 32 bit as well. Should these
> things be OK on a 64 bit box?
>
|||Awesome, thanks!
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:O6ea6xrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
> SQL Server depends on the OS architecture. So, if you are running as
> 32-bit OS then the 32-bit version of SQL Server is just fine. Even if you
> upgrade your OS to 64-bit you can still use the 32-bit version of SQL
> Server using Windows-on-Windows. Also, XP Pro 32-bit will work fine on
> 64-bit processors. However, the 32-bit OS cannot take advantage of the
> 64-bit hardware so you might look into upgrading to XP 64-bit.
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "ChrisR" <ChrisR@.NoEmail.com> wrote in message
> news:epmRRSrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
>