Analyse the impact and roadmap to move, under MSSQL, from ntext to nvarchar(max)

It seems that ntext is deprecated in latest MSSQL versions and the recommended way is to use nvarchar(max) instead.

Analyse how we can change that, their impact both in dml and ddl libraries.

Some initial references:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=421702&SiteID=1
http://msdn2.microsoft.com/en-US/library/ms189087.aspx