when i tried to change collation for a column I got this error--
Expression type tinyint is invalid for COLLATE clause.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/