Well, I know how to change collation for a server, database or a column. But not sure for a table. Googled. Found this page:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77212
It appears there are different points: (1) cannot do collation for table as stated by Kristen. (2) can change it through table design as in sherrymgm.
I tried the 2nd one. The 1st screen shot below is deceptive. It seems that you can change the collation for the table, as you coming to this screen by right-clicking the table. No! it's not for the table, it is for a particular column! Secondly, when you try to save the change (even though it is actually for a column), you will see the 2nd screen shot. You cannot save the change! You have to drop and re-create the table. Even so (dropping and re-creating), you are not defining collation for the table. It is actually for column(s).
So two thoughts on this issue:
(1) Concur with Kristen, no such a thing for table collation
(2) Poor GUI from MS on this issue. If the change cannot be saved, SSMS should prevent it from the very beginning, rather than disappointing the user at the last step.
P.S. Is "Column Collation" a better option than "Collation" on the SSMS GUI in this scenario?
