[ad_1]
Its a old version of mssql so does not support above solutions but when i tried like this it works
EXEC sys.sp_rename 'fg.TABLE NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME','COLUMN';
anyway thanks for your efforts
[ad_2]
solved How to rename a column in SQL Server 2005 [duplicate]