SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Setting Default DB in Query Button Bar Menu		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

KnooKie
Aged Yak Warrior

United Kingdom
623 Posts
Posted - 06/07/2012 :  09:52:37  Show Profile  Visit KnooKie's Homepage  Reply with Quote
Hi There

We have just moved from SQL Server 2005 to 2008.

I am using SQL Server Management Studio 2008 with SQL Server 2008 SP3 applied (so SSMS2008 version 10.0.5500.0)

In the 2008 management studio when clicking on the New Query button the drop down list of databases on the button bar menu shows master as the default DB.

Is there a way to change the default DB to a different DB ?

I'm sure you could do this in 2005 but can't seem to find an option for changing it in 2008 ?

Thanks

====
Paul

KnooKie
Aged Yak Warrior

United Kingdom
623 Posts
Posted - 06/07/2012 :  10:47:31  Show Profile  Visit KnooKie's Homepage  Reply with Quote
Remembered it now.

On the connect to Server login window click on the connection properties tab and select the database you want to have as the default when you're logged in.

These help if anyone has similar issues...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43696
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159028
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142030
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35835

====
Paul
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000