Hi,
I'm looking to change the collation on one of my databases so it can talk to another database on our server. Is there a quicker way of doing this other than creating a new database with the correct collation and copying the tables across to new database?
Your help would be much appreciated
Cheers