1     create table #mon__deadlock_info(-- 0 Rows, Data: 0 B, 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) not null,
32        ObjectName varchar(30) not null,
33        HeldUserName varchar(30) not null,
34        HeldApplName varchar(30) not null,
35        HeldHostName varchar(30) not null,
36        HeldClientName varchar(30) not null,
37        HeldClientHostName varchar(30) not null,
38        HeldClientApplName varchar(30) not null,
39        HeldTranName varchar(255) not null,
40        HeldLockType varchar(20) not null,
41        HeldCommand varchar(30) not null,
42        HeldProcDBName varchar(30) not null,
43        HeldProcedureName varchar(30) not null,
44        WaitUserName varchar(30) not null,
45        WaitApplName varchar(30) not null,
46        WaitHostName varchar(30) not null,
47        WaitClientName varchar(30) not null,
48        WaitClientHostName varchar(30) not null,
49        WaitClientApplName varchar(30) not null,
50        WaitLockType varchar(20) not null,
51        WaitTranName varchar(255) not null,
52        WaitCommand varchar(30) not null,
53        WaitProcDBName varchar(30) not null,
54        WaitProcedureName varchar(30) not null,
55        HeldSourceCodeID varchar(30) not null,
56        WaitSourceCodeID varchar(30) not null,
57        InstanceName varchar(30) not null,
58        ServerName varchar(30) not null,
59        ArchiveDate datetime not null,
60        VersionNum int not null,
61        ESDNum int not null,
62        EBFNum int not null
63    )
64    

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_monitor_deadlock_driver      called by proc sybsystemprocs..sp_monitor_deadlock         called by proc sybsystemprocs..sp_monitor