Default database for SQL Server login

October 24, 2023

Why do SQL Server Logins have a default database? Kenneth Fisher and Aaron Bertrand explain this here and here. Here is a sample script to identify logins whose default database no longer exists on the server. Once you identify, you can assign another database as default to avoid the issues explained in the abovementioned two […]