Introduction
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