SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. In SQL Server 2005, the data types text, ntext, and image were deprecated. This procedure finds any use of these data types, suggests a replacement, and provides the basic script required to change the data type.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com