MS-SQL: Convert all instances of one column type to another?

Question

I have an SQL Server 2008 database, which contains about 40 tables. Most of them contain at least a couple of varchar columns, and I want to convert every single one of those to nvarchar (of the same length). Also want to convert a number of text fields to nvarchar(MAX). Is there a simple, straightforward way to do this?

Answer 1

This seems very similar to the following question:

SQL Server Script to Update Database Columns from varchar to nvarchar...

Hope this helps!