> Hi,
>
> In SP2 it was determined to reduce the number of connections that a second
> or subsquent query would use the connection properties of the current
> connection context. If you had a quey open in msdb then if you opened an sql
> file it would open the second window also in msdb.
>
> Can this behaviour be reversed so that a new connection is requested first?
>
> Thanks
>
> Chris
>
>
>  

"Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message
news:OG9n6FPFIHA.1168@TK2MSFTNGP02.phx.gbl...
> Chris Wood wrote:
>> Hi,
>>
>> In SP2 it was determined to reduce the number of connections that a
>> second or subsquent query would use the connection properties of the
>> current connection context. If you had a quey open in msdb then if you
>> opened an sql file it would open the second window also in msdb.
>>
>> Can this behaviour be reversed so that a new connection is requested
>> first?
>>
>> Thanks
>>
>> Chris
>>
>>
> From the File Menu, you have the option to Open a file, a file with a new
> connection or a file disconnected (buttons already exist on the toolbar
> right next to the open file button).  You can also use the file menu to
> open a New Query with current connection or a Database Engine Query.  In
> fact, the button right next to the New Query button will open a new
> database engine query which will prompt for a new connection.