Different Collation

Can I restore a database to another server with different collation? I
think it is impossible but just wanted to double check. Thanks.
You can as of SQL Server 2000. But your applications might have problems if you don't have the same
collation in the app database as in the system databases. Ask your app vendor whether they have
tested for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ME" <ME@.mail.com> wrote in message news:%23ie8p5RmFHA.1232@.TK2MSFTNGP15.phx.gbl...
> Can I restore a database to another server with different collation? I think it is impossible but
> just wanted to double check. Thanks.
>

Different Collation

Can I restore a database to another server with different collation? I
think it is impossible but just wanted to double check. Thanks.You can as of SQL Server 2000. But your applications might have problems if
you don't have the same
collation in the app database as in the system databases. Ask your app vendo
r whether they have
tested for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ME" <ME@.mail.com> wrote in message news:%23ie8p5RmFHA.1232@.TK2MSFTNGP15.phx.gbl...agreen">
> Can I restore a database to another server with different collation? I th
ink it is impossible but
> just wanted to double check. Thanks.
>