Second method will loose all existing value in computed column so best is to go for first method, it will drop, recreate and populate column again.
But never forget to note computed column expression before dropping column.

Tuesday, September 3, 2013

While deployment a project on Production server I got an requirement to update my all LINKED Server references which is a very boring task to me.I found a very useful function on MSDN to check cross-database dependencies.

About Me

Working as a Team Lead(BI) in a Soft company. I have been working with Microsoft Technologies for the past 6 years. I am Microsoft Certified Professional(MCTS Sql Server 2005) and MCITP(Sql Server 2008 BI).
Highly interested in SSRS, SSIS, SSAS.