Thanks for reply

It was my bad

actual script is as below

declare @spid varchar(2)

declare @execstat nvarchar(10)

declare kill_cursor cursor

for

select spid

from sysprocesses sp, sysdatabases sdb

where sp.dbid=sdb.dbid

and name='database_name'

open kill_cursor

Fetch next from kill_cursor into @spid

while (@@fetch_status =0)

Begin

set @execstat ='kill'+' '+@spid

exec sp_executesql @execstat

fetch next from kill_cursor into @spid

End

Close kill_cursor

deallocate kill_cursor

Please help me into this