Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/1554844556377706498
deleted 15 characters in body; edited tags; edited title
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

How to Locate Locating the Resource System Database in MS SQL Serversystem database

There is a database called Resourcethe Resource database, which I know that is read only and contains information about system objects and does not save any user related data or metadata. 

I am using SSMS to manage my database instance and I can only see four system databases - master, model, msdb, tempdb. I'd like to know where can I find Resourcethe Resource database using SSMS? Or is Resourcethe database intentionally invisible for users?

Thanks for your time.

How to Locate Resource System Database in MS SQL Server

There is a database called Resource database, which I know that is read only and contains information about system objects and does not save any user related data or metadata. I am using SSMS to manage my database instance and I can only see four system databases - master, model, msdb, tempdb. I'd like to know where can I find Resource database using SSMS? Or is Resource database intentionally invisible for users?

Thanks for your time.

Locating the Resource system database

There is a database called the Resource database, which I know that is read only and contains information about system objects and does not save any user related data or metadata. 

I am using SSMS to manage my database instance and I can only see four system databases - master, model, msdb, tempdb. I'd like to know where can I find the Resource database using SSMS? Or is the database intentionally invisible for users?

Source Link
igelr
igelr
  • 2.2k
  • 3
  • 25
  • 54

How to Locate Resource System Database in MS SQL Server

There is a database called Resource database, which I know that is read only and contains information about system objects and does not save any user related data or metadata. I am using SSMS to manage my database instance and I can only see four system databases - master, model, msdb, tempdb. I'd like to know where can I find Resource database using SSMS? Or is Resource database intentionally invisible for users?

Thanks for your time.