Another quick server management studio quick tip. We had just set up a test server for our project, but everytime I used SQL server management studio, and ran a query, it would run it on Master database and not on our database. Just for convenience, you can set up the default DB as so:
1. In your object explorer > Expand Security > Expand Logins
2. Right click your login (in this case WeiL) and select ‘Properties’
3. Under General, you will see a drop down called “Default Database”
4. And ta-da! its done. 
4 Comments
December 15, 2008 at 7:21 pm
Cheers for the tip!
February 26, 2009 at 4:11 am
Indeed! Thanks…this has been driving me mad!
April 30, 2009 at 5:38 am
Woohoo, I could just kiss your feet. This has been driving me insane. I’m so happy to be able to set a default DB now, so I’m not running queries on master. xo
October 6, 2009 at 9:13 pm
Wonderful! This is incredibly useful information!