Timeline for hide system databases sql server management studio
Current License: CC BY-SA 3.0
4 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 19, 2018 at 12:01 | comment | added | spaghettidba | @MattiaNocerino because the documentation says so :-) Specifically, tempdb stores temporary objects (not only temp tables, but also sorts , hashtables and other types of temporary objects) so it always has to be available. Master contains system objects that have to be available, in the same way. | |
Mar 19, 2018 at 11:57 | comment | added | Mattia Nocerino |
"However, master and tempdb will always be visible to the public role" Why is that so? Is there a particular reason?
|
|
Dec 11, 2014 at 8:54 | history | edited | spaghettidba | CC BY-SA 3.0 |
added 99 characters in body
|
Dec 11, 2014 at 8:45 | history | answered | spaghettidba | CC BY-SA 3.0 |