mssqlsystemresource database is hidden intentionally. The
mssqlsystemresource is largely an implementation detail that allows the SQL Server installation and upgrade process to deploy new system objects versions without recreating objects in the master database as was done in SQL Server 2000 and earlier.
The physical location the
mssqlsystemresource database files is a well-known documented location. In SQL Server 2008 and later versions, this is the instance BINN folder (e.g. C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn) together with other SQL Server binaries. In SQL Server 2005, the
mssqlsystemresource were located in the same data folder as the master database files.
For learning, you can copy the
mssqlsystemresource.ldf to a user data folder, change file permissions, and attach the database using a different database name. This should only be done on an isolated test instance and will allow you to easily view the system objects in the
mssqlsystemresource database using SSMS.
CREATE DATABASE mssqlsystemresource_copy
LOG ON(NAME='log', FILENAME='D:\SqlDataFiles\mssqlsystemresource.ldf')