Hi Yakov,

The idea to replace the old ADT with a new ADT is good.  However, for maintenance purpose, I'm thinking whether I can replace the old ADT with a new ADT and then replace the new ADT with another ADT which has the same name as the old ADT but has the definition of the new ADT.

Replacing ADT for columns can follow the article and write a not too complicated script to go thru all tables in a database.  Writing a script to replace ADT in stored procedures may be complicated.  If there is a way to suppress SQL Server to check ADT existence in other SQL Server objects, then othe SQL Server objects may not need to be replaced.