Windows 7 Ultimate SP1 Key Windows 7 Professional SP1 Key Office Professional Plus 2016 Key canada goose outlet parajumpers belgie parajumpers sale

Change Default Database in SQL Server Management Studio

Change your login name and database name and Execute following SP:

Exec sp_defaultdb @loginame='imsatasia\Rahul', @defdb='DBName'


  • Go to “Object Explorer > Security > Logins”
  • Right click your Login and click on “Properties”
  • Under General Section, you can change Default Database value in drop down called “Default Database”

Set Default Database Name in SQL Server

» Need to Post HTML Code? Use Postable to post code friendly html. *Wrap all html code in <pre></pre> tags.