Whenever a sql login is created default DB is Master , I was able to change the default db to tempdb. Please explain what is the use of default DB & what will be the effect if we change the default db.
asked Feb 10, 2017 at 03:00 PM in Default
this is the database that the login is associated with as it's default. When the login connects to SQL Server, it goes first to this database.
Some reading material to help you out: https://msdn.microsoft.com/en-us/library/ms173768.aspx
answered Feb 10, 2017 at 06:02 PM