From: miroslavsi@gmail.com   
      
   Thank you very much.   
      
   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?   
      
   Thank you in advance.   
      
   "Plamen Ratchev"  wrote in message   
   news:jI-dnXpr9sTciATWnZ2dnUVZ_usAAAAA@speakeasy.net...   
   > My statement was incorrect about variables. Since they follow the rules   
   > for identifiers, they can be case sensitive depending on the collation.   
   > Here is from BOL:   
   >   
   > The collation of an identifier depends on the level at which it is   
   > defined. Identifiers of instance-level objects, such as logins and   
   > database names, are assigned the default collation of the instance.   
   > Identifiers of objects in a database, such as tables, views, and column   
   > names, are assigned the default collation of the database. For example,   
   > two tables with names that differ only in case can be created in a   
   > database that has case-sensitive collation, but cannot be created in a   
   > database that has case-insensitive collation.   
   >   
   > --   
   > Plamen Ratchev   
   > http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)