Today, my collegue asked me to change a filed collation from TaiWan to Latin1, I said he has dbo rights, why not change it by himself? He replied to me it is gray when he clicked the field from pop up property window. I noticed, yes, it is gray as thought as I am administrator. OK, to meet this problem, the good method is use script:
ALTER VIEW GetProducts
AS
SELECT ProductID, Name COLLATE Modern_Spanish_CS_AS FROM Production.Product