thanks for the reply.
now i am getting the following error.
Could not locate entry in sysdatabases for database 'sp_rename'dbo'. No entry found with that name. Make sure that the name is entered correctly.
quote:Originally posted by robprell
build a command string and then execute it.
set @cmd = 'sp_rename ''dbo.employees.id3'',' +††@name + ', ''COLUMN'''
then execute @cmd