SUMMARY
This document details the step-by-step instructions on how to change the default database on a SQL Server login.
- Grant the user with right to the database you want to set as the default database
- Connect to the database using SQL Server Management Studio with the login you wish to change
- Click New Query Button
- Execute the following command
- Alter login with default_database =