From: esquel@sommarskog.se   
      
   m (miroslavsi@gmail.com) writes:   
   > Now I have problem.   
   >   
   > I have database A and database B   
   >   
   > I made full backup of db A (example function "test" works properly >   
   > Insensitive collation)   
   > And restore that backup in db B.   
   >   
   > In database B example "test" function doesn't work properly!   
   >   
   > I thought if I make full backup of db A and restore it in db B, db B must   
   > have exact collation like db A?!   
   >   
   > I suppose there isn't easy way to covert database collation?   
      
   Are the databases on the same server or on different ones? If the   
   servers are different, they may have different server collation.   
      
   When you say "restore that backup in db B", this in accurate. More correctly   
   is to say "restore that back *as* db B". Because, when you restore a backup   
   into an existing database, everything in it is flattened.   
      
   If you have further questions, please describe more closely what   
   "doesn't work properly means".   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)