GeekZilla
Setting default collation on a column
The following will set the collation on a column in a table back to Database Default without dropping and recreating the table (unlike Enterprise Manager)
ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] varchar(50) COLLATE database_default NOT NULL GO
Author Paul Hayman
Paul is the COO of kwiboo ltd and has more than 20 years IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services.
Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.