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

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