1 create table monProcessProcedures(-- 0 Rows, Data: 2 KB, Index: 0 B
2 SPID int not null,
3 InstanceID tinyint not null,
4 KPID int not null,
5 DBID int not null,
6 OwnerUID int not null,
7 ObjectID int not null,
8 PlanID int not null,
9 MemUsageKB int not null,
10 CompileDate datetime not null,
11 ContextID int not null,
12 LineNumber int not null,
13 StatementNumber int not null,
14 ExecutionCount int not null,
15 CPUTime int not null,
16 ExecutionTime int not null,
17 PhysicalReads int not null,
18 LogicalReads int not null,
19 PhysicalWrites int not null,
20 PagesWritten int not null,
21 DBName varchar(30) null,
22 OwnerName varchar(30) null,
23 ObjectName varchar(30) null,
24 ObjectType varchar(32) null
25 )
26
27 Grant Select on monProcessProcedures to mon_role
28
ALIASES USED for master..monProcessProcedures |
m |
1 |
SCHEMA |
|
QUERIES |
Joined With | Links |