DatabaseTableApplicationCreatedLinks
mastermonRepScanners  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monRepScanners(-- 0 Rows, Data: 2 KB, Index: 0 B
2         DBID int not null,
3         SPID int not null,
4         InstanceID tinyint not null,
5         EngineBinding int not null,
6         LogRecordsScanned int not null,
7         LogRecordsProcessed int not null,
8         NumberOfTruncPointRequested int not null,
9         NumberOfTruncPointMoved int not null,
10        DBName varchar(30) null,
11        Status varchar(30) null,
12        SleepStatus varchar(30) null,
13        StartMarker varchar(30) null,
14        EndMarker varchar(30) null,
15        CurrentMarker varchar(30) null,
16        OldestTransaction varchar(30) null
17    )
18    
19    Grant Select on monRepScanners to public
20    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[DBID]master..sysdatabases[dbid]6 FK
[DBID]master..monRepSenders[DBID]4 Simple Join
[SPID, DBID]master..monRepSenders[DBID, SPID]2 Simple Join

ALIASES USED for master..monRepScanners
scan
7

SCHEMA

COLUMN USAGE
DBIDsp_help_rep_agent 
SPIDsp_help_rep_agent 
LogRecordsScannedsp_help_rep_agent 
DBNamesp_help_rep_agent 
Statussp_help_rep_agent 
SleepStatussp_help_rep_agent 
StartMarkersp_help_rep_agent 
EndMarkersp_help_rep_agent 
CurrentMarkersp_help_rep_agent 

QUERIES
Joined With Links
master..sysdatabases sybsystemprocs..sp_help_rep_agent:300
sybsystemprocs..sp_help_rep_agent:382
master..sysdatabases master..monRepSenders sybsystemprocs..sp_help_rep_agent:205
master..monRepSenders sybsystemprocs..sp_help_rep_agent:277
sybsystemprocs..sp_help_rep_agent:183

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_help_rep_agent