I am running MS SQL 2005 with several development databases. Somehow the collation between tempdb and one of my db's got messed up. Now I'm getting this error all over the place:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
I tried changing tempdb's collation but ms sql wouldn't alllow it on a system db. There's too many tables involved to slap collate statements everywhere. Short of dropping the data, is there anyway to get the 2 back in synch? This problem is driving me nuts..