|
Home > Archive > MS SQL Server Tools > March 2006 > SSMS 2005 Default DB in Solution Explorer when creating new query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SSMS 2005 Default DB in Solution Explorer when creating new query
|
|
| SteelMillDon 2006-03-14, 7:23 am |
| Hi,
Every time I create a new query from the SSMS 2005 Solution Explorer it
defaults to a DB that I was working on before. How do I change the default DB
in the connection or for creating a new query?
Thanks
| |
| Wei Lu 2006-03-14, 8:24 pm |
| Hi Steel,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: you want to open
a Code Editor window using a particular database. If I misunderstood your
concern, please feel free to point it out.
Just right-click the database you want to editor code and then click New
Query. The Code Editor window will using a particular database.
Also you can change the database you using. On the tool bar , before the
Execute button, you can see the Database you are using. You can choose the
database you want to edit code in the dropdown list.
Hope this will be helpful!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| Greg Rowland 2006-03-15, 3:23 am |
| How bout if the UI was smart enough to know what database I have been
working in all day? Worked Great in SQL 2000 Query Analyzer!
The Quest Continues,
GR
|
|
|
|
|