How to view the contents of SQL Server Resource Database

  • [アーティクル]

To be able to view the SQL Server Resource Database

 A) SQL Server must be started in a Single user Mode

      Start with -m flag in configuration manager

 Even if the Server is started in Single user mode, the database will still not be visible in sys.databases view

Open the database with the use command

USE mssqlsystemresource

SELECT * from Sys.objects

Comments