sp_who2
go
sp_lock 964
go
--spid dbid ObjId IndId Type Resource Mode Status
--961 1 85575343 0 TAB IS GRANT
--964 9 201767776 3 PAG 1:6789 IX GRANT
--964 9 201767776 1 PAG 1:6786 IX GRANT
--964 9 201767776 2 PAG 1:6787 IX GRANT
--964 9 201767776 3 KEY (e4005edd4dfd) X GRANT
--964 9 201767776 1 KEY (d6000bcda4b6) X GRANT
--964 9 201767776 2 KEY (3200c2e1bde2) X GRANT
--964 9 201767776 0 TAB IX GRANT
select object_name(201767776)
go
-- process 확인
SELECT * FROM master..sysprocesses
where spid = 964
gp
-- process kill 시킨다.
kill 964
'Transact-SQL' 카테고리의 다른 글
Clustered Index Rebuild시 UNIQUIFIER Key 값이 변할까요 안 변할까요?? (0) | 2011.08.02 |
---|---|
인덱스를 리빌드 + 통계 업데이트를 한꺼번에^^ (0) | 2011.04.26 |
Top 10 Dev Mistakes That Don’t Scale (0) | 2010.07.16 |
20080715-Avoid Untrusted Constraints in SQL Server (1) | 2008.07.15 |
SQL Server Code Deployment Best Practices (0) | 2008.07.11 |