Sql server updating a master database
Hello, I was adding a SQL Agent Alert to check the data file size of a user database and e-mail me if it increased beyond a certain threshold.While setting up this alert, I checked the size of the data file using SSMS (right-clicked the user database and selected Tasks / Shrink / Files) and deliberately set the alert threshold to a value lower than this to test that the alert worked.The alert certainly did its job immediately, however the current value reported in the e-mail was significantly higher than what I was expecting.Having a firm understanding of the SQL Server databases is beneficial when you need to troubleshoot an issue, gather data from SQL Server, etc.
This tip will outline the SQL Server system databases, explain the core objects used in the relational databases and outline some do's and don'ts when working with the system databases.
Is a read-only database that contains system objects that are included with SQL Server.
Sql server updating a master database comments