Sue Swanson (swansons@optimalinternet.com) writes:
> Yesterday I received a response to my CI/CS Collation problem and the
> recommendation was to try and restore a CI Collation database to a CS
> Collation database. After creating a blank CS database a full restore
> (Force restore over existing database) does change the Collation to
> CI. I'm unsure as to how I can restore without changing the
> Collation. Any suggestions?

This does not seem like a workable way to me. It is possible
that the default for new tables in the new database would be CS, but
the existing tables in the backup would retain their CI collation.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp