DatabaseTableApplicationCreatedLinks
mastermonProcessLookup  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monProcessLookup(-- 0 Rows, Data: 2 KB, Index: 0 B
2         SPID int not null,
3         InstanceID tinyint not null,
4         KPID int not null,
5         KTID int not null,
6         Login varchar(30) null,
7         Application varchar(30) null,
8         ClientHost varchar(30) null,
9         ClientIP varchar(64) null,
10        ClientOSPID varchar(30) null,
11        ClientName varchar(30) null,
12        ClientHostName varchar(30) null,
13        ClientApplName varchar(30) null
14    )
15    
16    Grant Select on monProcessLookup to mon_role
17    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[SPID]master..monProcessWaits[SPID]2 Simple Join

ALIASES USED for master..monProcessLookup
mpl
1

SCHEMA

COLUMN USAGE
SPIDsp_monitor_event 

QUERIES
Joined With Links
master..monProcessWaits master..monWaitEventInfo sybsystemprocs..sp_monitor_event:73

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_event