1 create table monDeadLock(-- 0 Rows, Data: 2 KB, Index: 0 B
2 DeadlockID int not null,
3 VictimKPID int not null,
4 InstanceID tinyint not null,
5 ResolveTime datetime not null,
6 ObjectDBID int not null,
7 ObjectID int not null,
8 PageNumber int not null,
9 RowNumber int not null,
10 HeldFamilyID int not null,
11 HeldSPID int not null,
12 HeldKPID int not null,
13 HeldInstanceID int not null,
14 HeldProcDBID int not null,
15 HeldProcedureID int not null,
16 HeldBatchID int not null,
17 HeldContextID int not null,
18 HeldLineNumber int not null,
19 HeldStmtNumber int not null,
20 HeldNumLocks int not null,
21 WaitFamilyID int not null,
22 WaitSPID int not null,
23 WaitKPID int not null,
24 WaitProcDBID int not null,
25 WaitProcedureID int not null,
26 WaitBatchID int not null,
27 WaitContextID int not null,
28 WaitLineNumber int not null,
29 WaitStmtNumber int not null,
30 WaitTime int not null,
31 ObjectDBName varchar(255) null,
32 ObjectName varchar(30) null,
33 HeldUserName varchar(30) null,
34 HeldApplName varchar(30) null,
35 HeldHostName varchar(30) null,
36 HeldClientName varchar(30) null,
37 HeldClientHostName varchar(30) null,
38 HeldClientApplName varchar(30) null,
39 HeldTranName varchar(255) null,
40 HeldLockType varchar(20) null,
41 HeldCommand varchar(30) null,
42 HeldProcDBName varchar(30) null,
43 HeldProcedureName varchar(30) null,
44 WaitUserName varchar(30) null,
45 WaitApplName varchar(30) null,
46 WaitHostName varchar(30) null,
47 WaitClientName varchar(30) null,
48 WaitClientHostName varchar(30) null,
49 WaitClientApplName varchar(30) null,
50 WaitLockType varchar(20) null,
51 WaitTranName varchar(255) null,
52 WaitCommand varchar(30) null,
53 WaitProcDBName varchar(30) null,
54 WaitProcedureName varchar(30) null,
55 HeldSourceCodeID varchar(30) null,
56 WaitSourceCodeID varchar(30) null
57 )
58
59 Grant Select on monDeadLock to mon_role
60
ALIASES USED for master..monDeadLock |
NO_ALIAS |
1 |
SCHEMA |
|
QUERIES |
Joined With | Links |