mssqlÊý¾Ý¿â»Ö¸´ÎÊÌ⣬¼±
ÎÒÏëÔÚJspÒ³ÃæÀïÃæ»Ö¸´Êý¾Ý¿â£¬²Î¿¼ÁËһЩ×ö·¨£¬Óô洢¹ý³Ì¶Ï¿ªÊý¾Ý¿âµÄÁ´½Ó¡£
/*
¹Ø±ÕÓû§´ò¿ªµÄ½ø³Ì´¦Àí
*/
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)
Ïà¹ØÎÊ´ð£º
ÓÐ沒ÓÐ辦·¨實現£¬從MSSQL2000Æó業¹ÜÀíÆ÷註冊MSSQL2008數據庫£¿
Á¬²»ÉϰÉ
Ã²ËÆ沒Ï£Íû¡£¡£¡£
Ó¦¸ÃÊDz»ÐÐµÄ ¿çÌ«¶àÁË
ÄÇ2000µÄ ......
×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôÔÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
˽â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?
ÒýÓÃ
×î½üÏÂÃæ ......
ÎÒÕýÔÚ×öÒ»¸öÅÅÐаñ±í(T_hist)
±íÄÚÓÐ qid(Íâ¼ü) ÈÕÅÅÐаñ(dhits) ÖÜÅÅÐаñ(whits) ÔÂÅÅÐаñ(mhits) ×ÜÅÅÐаñ(hits) ¶¼ÊÇintÀàÐÍ
ÎÒÏÖÔÚÏë×ö¸ö´¥·¢Æ÷ ÿÈÕÁãµã°ÑËùÓÐÐеÄdhits×Ö¶ÎÇå ......
ÎÒÏëÎÊÏÂÐéÄâÖ÷»úÔËÓªÉ̵ÄMSSQL¿Õ¼ä¿É²»¿ÉÒÔÔ¶³ÌÁ¬½Ó£¿
¾ÍÊÇ˵ÔÚÎҵĻúÆ÷ÉÏÄܲ»ÄÜÓÃSSMSÁ¬½ÓËûµÄ·þÎñÆ÷
Èç¹ûÓÐÇë¸æËßÎÒÔËÓªÉ̵ĵØÖ·£¬Ð»Ð»£¡
ÔËÓªÉ̵ĵØÖ·½ÐÔËÓªÉ̸æËßÄ㣬¹Ø¼üµÄÊÇËû³ýÁËÔÊÐíÄãµÄ»úÆ÷Á¬½ÓÍ⣬»¹µ ......