Block user objects from being created in a master database


The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can’t run without access to a fully functional master database. It’s highly recommended not to use it to store any user database objects.

This article is going to discuss why user objects end up created in a master database and how to prevent this from happening.

The Problem

The main problem is SSMS’ default behavior (to be exact, this is not