I want to rename the column name by using the dynamic value
as like

declare @name as varchar(12)
set @name='ss'
sp_rename 'dbo.employees.id3',@name, 'COLUMN';
go

but it shows the error
Incorrect syntax near 'sp_rename'.

any idea?

build a command string and then execute it.

something like:
set @cmd = 'sp_rename ''dbo.employees.id3'',' + @name + ', ''COLUMN'''

then execute @cmd

hi
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.

help me.

I think you need to do master.dbo.sp_rename

or whatever database it is in that your using it with.

If you specify the fully qualified name I think that should fix your problem.