Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

MS SQL Server Management Studio

  
   Database Forums (Home) -> Tools RSS
Next:  Directory matters: help  
Author Message
Waldy

External


Since: Oct 08, 2008
Posts: 6



(Msg. 1) Posted: Wed Nov 26, 2008 7:26 am
Post subject: MS SQL Server Management Studio
Archived from groups: microsoft>public>sqlserver>tools (more info?)
Hi there,
if I am connected to a server in object explorer and I then
open a query window or open a file, is there any way that I can get
Management Studio to use the current connection as in the Object Explorer
instead of prompting me to log in again and connecting to the master
database instead of the one that I am working on?

 >> Stay informed about: MS SQL Server Management Studio 
Back to top
Login to vote
Russell Fields

External


Since: Feb 21, 2007
Posts: 457



(Msg. 2) Posted: Wed Nov 26, 2008 8:40 am
Post subject: Re: MS SQL Server Management Studio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Waldy,

If I highlight a database in Object Explorer and hit Ctrl-N I get a query
window connected to the highlighted database. If I just have the servername
or the Database node highlighted, I get a query window connected to my
default database. (Which may be master for you.)

If I do Help / About from Management Studio it reports my tool version as
9.00.3042. What do you get? Are you still running the original install of
the tools? or SP1? SP2? CU9? (And SP3 is coming Real Soon Now.) I
remember more connection prompts with the earliest versions of Management
Studio.

FWIW,
RLF


"Waldy" wrote in message

> Hi there,
> if I am connected to a server in object explorer and I then
> open a query window or open a file, is there any way that I can get
> Management Studio to use the current connection as in the Object Explorer
> instead of prompting me to log in again and connecting to the master
> database instead of the one that I am working on?
>

 >> Stay informed about: MS SQL Server Management Studio 
Back to top
Login to vote
Aaron Bertrand [SQL Serve

External


Since: Jun 15, 2005
Posts: 632



(Msg. 3) Posted: Wed Nov 26, 2008 11:13 am
Post subject: Re: MS SQL Server Management Studio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
If you right-click the server/database in Object Explorer and select New
Query, you will have the right context in the new query window. If you use
Ctrl+N or open a file, then where it connects will depend on the focus
context in Object Explorer. If you have no context in Object Explorer then
it will prompt (though I think Russell is correct that this behavior has
improved over time and with newer updates to the tools).





"Waldy" wrote in message

> Hi there,
> if I am connected to a server in object explorer and I then
> open a query window or open a file, is there any way that I can get
> Management Studio to use the current connection as in the Object Explorer
> instead of prompting me to log in again and connecting to the master
> database instead of the one that I am working on?
>
 >> Stay informed about: MS SQL Server Management Studio 
Back to top
Login to vote
Waldy

External


Since: Oct 08, 2008
Posts: 6



(Msg. 4) Posted: Wed Nov 26, 2008 12:25 pm
Post subject: Re: MS SQL Server Management Studio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks Guys,
I am on version 9.00.3042. I think the difference is
when the highlight colour in the object explorer is blue or grey. It is
blue if the object explorer has focus and grey when another window has
focus. Although a database may be highlighted in the explorer, if that
window does not have focus, you get the prompt.

I thought that the behaviour seemed to be random, but I now understand what
is happening.
 >> Stay informed about: MS SQL Server Management Studio 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Server Management Studio - Is it possible to delete a group of stored procedure in one action, as it was using the mmc in SQL2000 ? Or do I have to delete each store proc one at a time ???

where is SQL Server Management Studio? - Hi, I've installed SQL Server 2005 Dev and VS 2005 pro. I just can't find SQL Server Management Studio from the menu start-> programs-> SQL Server 2005. Can you help me? Thank you.

Alternative to SQL Server Management Studio? - Does anyone have any suggestions for 3rd party tools to replace SQL Server Management Studio. SMS is such bloatware and lacks so many nice features of Enterprise Manager that there must be some decent tools out there to use instead. I know there's..

SQL Server Management Studio and Backup Log ... with no_tr.. - Hi, When I put one database offline using Management Studio the option Backup in object explorer is disable. I execute the backup log ... with no_truncate in query window because the option is disable. In Enterprise Manager (SQL 2000) the option..

SQL Server Management Studio Express error - When trying to open tables in remote SQL 2000 database I get error InvalidArument=Value of '6' is not valid for 'index' Parameter name:index The database is up and running so it's not a problem with the table itself. Any suggestions on how to resolve...
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]