August 24, 2007 at 7:58 am
This is a small thing but bugs me. In Query Analyzer when you open a session and set the database you could drop and drag files and they open new windows using the same db context. In management studio, the files open in your default database.
I've looked in the menu's and the help but can't find a way to reset the behavior. If your doing a code push it is just annoying.
That is my rant and I'm sticking to it.
David
August 24, 2007 at 8:05 am
David,
do you have the Query Execution->SQL Server->Advanced->Disconnect after the query executes set?
Andras
August 24, 2007 at 8:23 am
No, I do not.
August 24, 2007 at 9:17 am
Do you have the latest service pack? There was an update I think in SP2 that allowed you to create a new query window or open a new file and not prompt you to connect to the db.
August 24, 2007 at 10:00 am
Help about shows:
Microsoft SQL Server Management Studio9.00.3042.00
I think that is the latest ver.
August 24, 2007 at 10:39 am
Because mistakes tend to be made pushing scripts like this, I require a USE <DBNAME> to start all the scripts I run...its safer, and, would solve this issue...
-- Cory
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply