colation & multi DB's

• • Reply

  17 years ago

  by dtth555

  Joel Meikle

  New Zealand, New Zealand

  Joined 17 years ago

  Hi, I am having trouble changing views & functions that do a multi database query.
  

  
  I needed to create some views & functions to do a multi db query and had to put the name of the 2nd database name in the select statements.
  

  
  Now i need to change the 2nd db name on a semi live database and I am unable to due to collation problems?
  

  
  if they need to be the same collation (which they are not for some reason) can i change the existing 1st db to a different collation? how?
  

  
  How can i avoid this issue in the future.
  

  
  Thanks for your time.

  Report abuse