0  419    21  21

Name	곽진석
Subject	Lock 걸린 현황 파악

use master create proc sp_block   as   if exists (select * from sysprocesses where spid in     (select blocked from sysprocesses))   select spid,blocked,status,   loginame,   hostname,   dbname = substring(db_name(dbid), 1, 10)     ,cmd   from sysprocesses   where blocked <> 0   or (spid in (select blocked from sysprocesses))   else   print 'No one is blocked'

Prev	날짜 관련 함수	곽진석

Next

마지막으로 처리한 커리

곽진석

Copyright 1999-2022 Zeroboard / skin by JiYoo