Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 change collation

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2010-05-24 : 09:45:50
I have two databases that are often joined in querys. I have noticed that they have different collations.
I think this is causing errors.
I went into SSMS and went to the properties of on eof the databases and set the collation. But someone told me that this will only affect new entries.
is there a way I can do this on the whole database within the GUI?

Thanks
   

- Advertisement -