1 create table syssrvroles(-- 0 Rows, Data: 2 KB, Index: 4 KB
2 srid int not null,
3 name varchar(30) not null,
4 password varbinary(128) null,
5 pwdate datetime null,
6 status smallint null,
7 logincount smallint null,
8 locksuid int null,
9 lockreason int null,
10 lockdate datetimn null
11 )
12
13 create unique clustered index csyssrvroles on syssrvroles(-- 2 KB refcount: 27
14 srid
15 )
16
17 alter table syssrvroles lock datarows
18
19 Grant Select on syssrvroles to public
20 Grant Select on syssrvroles to sso_role
21
Estimated Index Usage |
syssrvroles.csyssrvroles unique clustered(srid) | 27 |
ALIASES USED for master..syssrvroles |
NO_ALIAS | a | r | rolename | srvro |
23 | 1 | 9 | 1 | 9 |
SCHEMA |
|