我用企業管理器打開我的某張裱,齣現: An unexpected error happened during this operation. [Query]-Query Designer encountered a Query error: Unspecified err 從此我的這張裱就在企業管理器中打不開暸,每次打開都是上麵的信息。 但是我用查詢分析器卻是可是訪問及別的一些操作。 請問我該怎么解決
===>
DBCC results for 'a'.
There are 24 rows in 1 pages for object 'a'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
use master
go
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500),@temp varchar(1000)
declare @spid int
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status < >-1
begin
set @temp='kill '+rtrim(@spid)
exec(@temp)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
end
1、
use master
go
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500),@temp varchar(1000)
declare @spid int
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status < >-1
begin
set @temp='kill '+rtrim(@spid)
exec(@temp)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
end