I'm not sure if this works in 6.5 but the method I usually use is:

sp_rename 'tablename.columnname', 'newcolumnname'

To find out where the column exists in each database you clould use:

SELECT name...