Ok, I am SQL newbie!
I have a sql 2005 database that somehow the COLLATION property of almost every column has changed from DATABASE DEFAULT to SQL_Latin1_General_CP850_C
I_AS. Is there a way to do a mass change of the COLLATION value to be DATABASE DEFAULT for all my columns?
I have included a screenshot of the column properties.