--查询分析器中执行下面的语句:/*
关闭用户打开的进程处理
*/
use master
goif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_killspid]
GOcreate 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 'test '
goRESTORE DATABASE test FROM DISK='C:\\My Documents\\111.db' WITH NORECOVERY
关闭用户打开的进程处理
*/
use master
goif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_killspid]
GOcreate 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 'test '
goRESTORE DATABASE test FROM DISK='C:\\My Documents\\111.db' WITH NORECOVERY
解决方案 »
- 三表联合查询,按产地排序,并要求每个产地中有一个最低价格的sql语句
- 当写有判断条件的存储过程时候,总是很难写对小括号之类的,大家怎样对付的?
- SQL Server导入数字数据到Excel显示为文本,大伙帮忙看看
- sqlserver2005 登录失败问题....
- SQL中查找多个不重复的列,用distinct还是group by速度会快一点?
- 关于字符型和整型的一个问题
- 关于varchar类型2个问题
- 请问,我建立一个表,执行下面语句,但提示有语法错误,请帮忙修改?
- 请高手推荐将1NF分解成3NF的书
- 这个查询如何做
- 关于数据库查询并进行统计的问题,请教各位!
- 系统存储过程的结果集如何才能拿来用?急!
GO
use master
go
RESTORE DATABASE test FROM DISK='C:\\My Documents\\111.db' WITH NORECOVERY
GO
我試過這樣也可以的.
RESTORE DATABASE test FROM DISK='C:\\My Documents\\111.db' WITH RESTART
大侠我按照你的试了啊!但是还是不行啊!非要在数据库的本机操作吗?