急,在线等待

[cxyPioneer]

use master
go
if exists (select name from sysobjects where name='killprocess' and type='p')
drop procedure killprocess
go
create procedure killprocess
@dbname char(50),
@@proId int
as
select @@proId = DB_ID(name) FROM sysdatabases where name = @dbname

上面的这个存储过程能不能直接在SQL语句中,实现kill @@proId 进程号杀掉,或者其他方法再用restore database pubs from disk=数据库名字来恢复数据库

[pbsql]

完整的如下：
use master
go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_killspid]
GO

create proc p_killspid
@dbname varchar(200) --要关闭进程的数据库名
as
declare @sql nvarchar(500)
declare @spid nvarchar(20)

declare #tb cursor for
select spid=cast(spid as varchar(20)) from master..sysprocesses where dbid=db_id(@dbname)
open #tb
fetch next from #tb into @spid
while @@fetch_status=0
begin
exec('kill '+@spid)
fetch next from #tb into @spid
end
close #tb
deallocate #tb
go

--用法
exec p_killspid '数据库名'