64bit vs 32bit

If I create a database on 64bit version of SQL 2005 and then copy it to a
32bit version SQL 2005 will that database still work? and/or will
adminstrators have to make setting changes?All Editions of SQL within a major version maintain user database on-disk
compatibility across all architectures. That is a very complex way of
saying that any database created on any version/edition/processor
combination of SQL 2005 can be restored or copied to a SQL instance on any
other version/edition/processor combination. The sole exception is that SQL
Express will not accept a database over its 4GB size limit.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:C85E4CF8-BA5D-4300-898F-49650A72627C@.microsoft.com...
> If I create a database on 64bit version of SQL 2005 and then copy it to a
> 32bit version SQL 2005 will that database still work? and/or will
> adminstrators have to make setting changes?|||In other words "yes it will work, all other things being equal".
;)
*mike hodgson*
http://sqlnerd.blogspot.com
Geoff N. Hiten wrote:

>All Editions of SQL within a major version maintain user database on-disk
>compatibility across all architectures. That is a very complex way of
>saying that any database created on any version/edition/processor
>combination of SQL 2005 can be restored or copied to a SQL instance on any
>other version/edition/processor combination. The sole exception is that SQ
L
>Express will not accept a database over its 4GB size limit.
>
>