All my servers have a default collation of Latin1_General_CPI_CI_AS. Apart from one that is. It was rebuilt with the wrong collation of Latin1_General_CI_AS. This is causing problems with an application and the collation needs to be changed to be the same as all the other servers.
I know I could create scripts for all the objects, rebuild the master database, recreate the user databases and then create the objects and BCP all the data over, but this sounds a bit nasty.
Can anyone suggest a quicker and easier way to accomplish this?
P.S. The server that was wrongly built was done so before I started this job, honest.