Following query can be used to rename column in mssql 2005. EXEC sp_rename @objname = ‘table_name.old_column_name’, @newname = ‘new_column_name’, @objtype = ‘COLUMN’

Following query can be used to rename column in mssql 2005. EXEC sp_rename @objname = ‘table_name.old_column_name’, @newname = ‘new_column_name’, @objtype = ‘COLUMN’