MS SQL Server Tools - Management Studio: DB Context: Script Opens a new connection

Author

Management Studio: DB Context: Script Opens a new connection - How do I get script to reuse the con

Chuck Hawkins

2005-12-06, 1:23 pm

I just partially discovered how to work around something that was driving me
crazy.

When I was opening up a script to apply to a database, the Query Windows was
always opening a new connection to the Master Database. I want Query
Anazlyzer-like functionality where the script is opened in the same
connection to the same database, causing me not to have 10 succesive windows
open when I open and quickly run 10 successive scripts. Instead what was
happening was each script opens a new connection to the master DB.

I discovered that if I change the database one time in the Connection
Properties tab of the Connect to Database Engine window, exposed after
clicking the Options>> button successive windows will at least open up in
the same database context and I don't have to keep switching from Master.

Now, how do I get Management Studio to re-use the same connection for
succesive scripts?

Thanks,

Chuck Hawkins

Sponsored Links