Hi, this one is for the lazy programmers (like I). If you work a lot of time on the same project chances are that you know that every time you create a new query on SQL Server Management Studio it always sets your connection to the Master database. For those who are annoyed like me, you can configure the default database of your user to whatever you want.
- On the Object Explorer expand the Security folder.
- Expand the Logins folder.
- Right click your user and select Properties.
- Now select the Default Database you want.
That’s it!
