This is one of them little options that I see which quite often gets little consideration, or gets set to a user database without consideration of what the consequences may be if that default database becomes unavailable. There are going to be situations where setting a default database other than the master database is essential.... Continue Reading →
SQL Server login – default database and failed logins
SQL Undercover 