data-konzept

'During interviews there would be at least one question asked about system databases and someone might ask about hidden system database is – mssqlsystemresource. There are a few facts which are known to most of us:

1. It is a hidden system database. ID of this database is 32768.

2. It stores schema of system object.

3. It helps in faster patching because there is no need to ALTER system objects. Since the schema is stored in this database, it would be just replacing mdf and ldf files.

There are a few mythsmyths about this database, none of below is true'...

http://blog.sqlauthority.com/2015/09/11/sql-server-how-to-view-objects-in-mssqlsystemresource-system-database/