Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-11-24 : 06:56:13
|
| How often are the sys. tables/objects etc updated?As I've done some alterations to permissions/roles/schemas and they don't show up when I interrogate the sys.database_role_memberssys.objectssys.schemassys.database_permissionssys.database_principalsetc, as I'm mapping permissions for documentation purposes.Cheers, if anyone knows, not a prob if they only get updated overnight or something as I'll run the scripts again tomorrow. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-24 : 11:12:36
|
| they get updated in real time. |
 |
|
|
|
|
|
A quick question - if anyone knows?