非淡泊无以明志,非宁静无以致远 -心静如止水,动于静

How to change collation of a view

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

posted @ 2010-11-10 14:17  烟雨客  阅读(158)  评论(0)    收藏  举报