rem 可根据实际情况修改磁盘路径DMPPATH=d:\dumps
SET DMPPATH=c:\dumps
SC CONFIG WerSvc START= AUTO
NET START WerSvc
ECHO 启用完成

REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AeDebug\Debugger /f
REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\DbgManagedDebugger /f

REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows NT\CurrentVersion\AeDebug\Debugger /f
REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\DbgManagedDebugger /f

ECHO 删除完成

REG ADD “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\w3wp.exe” /f
REG ADD “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\w3wp.exe” /t REG_SZ /v DumpFolder /d %DMPPATH% /f
REG ADD “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\w3wp.exe” /t REG_DWORD /v DumpCount /d 2 /f
REG ADD “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\w3wp.exe” /t REG_DWORD /v DumpType /d 2 /f

ECHO 启用完成

PAUSE

declare @name varchar(100)
declare cur cursor for
select name from sysobjects where xtype=’u’ order by name
open cur
fetch next from cur into @name
while @@fetch_status=0
begin

dbcc checktable(@name)

fetch next from cur into @name
end
close cur
deallocate cur

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     ‘数据库名’