Run this script, it will generate scripts to rename columns of table, then run those scripts..


SELECT 'EXEC sp_rename ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' + 
COLUMN_NAME + ''', ''' +
UPPER(COLUMN_NAME) + ''',''COLUMN'''
FROM INFORMATION_SCHEMA.COLUMNS
WHERE OBJECTPROPERTY(OBJECT_ID('[' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']'),
'isMSShipped') = 0 and substring(TABLE_NAME,1,2) <> 'vu'