How to change default database in SQL Server without using MS SQL Server Management Studio?
What you can do is set your default database using the sp_defaultdb system stored procedure. Log in as you have done and then click the New Query button. After that simply run the sp_defaultdb command as follows: Exec sp_defaultdb @loginame=”login”, @defdb=’master’