This is a strange one.
I have a SQL2000 server that has been set up for collation SQL_Latin1_General_Pref_CP850_CI_AS
However when i add a new table, the collation for varchar fileds is created as SQL_Latin1_General_CP1_CI_AS
What the hell is going on?
All the tables i have moved from my otherserver that were cp850 are now also cp1! How can i get the default collation to work again?