DECLARE @tableName NVARCHAR(50)

DECLARE @sql NVARCHAR(200)

DECLARE LangTable CURSOR FOR

SELECT name  FROM sys.tables WHERE name LIKE '%Language'

    OPEN LangTable

    FETCH NEXT FROM LangTable INTO @tableName

    WHILE @@FETCH_STATUS = 0

    BEGIN

    SET @sql = 'ALTER TABLE  '+@tableName+' ALTER COLUMN LanguageDesc NVARCHAR(MAX)'

    EXEC @sql

    FETCH NEXT FROM LangTable INTO @tableName

    END

CLOSE LangTable

DEALLOCATE LangTable