SET DATABASE DEFAULT IN server mangement studio

Question

Exec sp_defaultdb @loginame='sa', @defdb='HOB2016'

Answer 1

Steps: 1) Open Sql Server Management Studio
 2) Go to object Explorer -> Security -> Logins
 3) Right click on the login and select properties
 4) And in the properties window change the default database and click OK.