By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,410 Members | 1,626 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,410 IT Pros & Developers. It's quick & easy.

SQL Server 2005 - Open SQL file with Query Analyzer behavior

P: 15
Hello!

My company recently upgraded to SQL Server 2005 and I'm still getting used to the new interface. One thing I've noticed:

When I'm connected to a specific database and I want to run a script, I click New Query, Open File then select the script. SQL Server 2005 brings up the "Connect to Database Engine" dialog again and the resets the database to master.

This is a bit annoying, especially since Query Analyzer would allow me to open a new query window then open a script into it without resetting everything.

Can anyone shed some light on how I might alter this behavior? Is there something in the options, perhaps?

Thanks a million!!
Mar 17 '09 #1
Share this Question
Share on Google+
1 Reply


P: 15
I started saving my query with

USE DATABASENAME

SELECT X
FROM X

This may not be the answer you are looking for but it saved me a couple of clicks
Mar 17 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.