The "Microsoft SQL Server Management Studio" opens a connection dialog with every new query. Please tell me there is setting to prevent this.
Thanx,
Greg
The popup of the dialog is related to your current context. If you have object explorer open and a server connected then the query will be connected to that server. If you have an existing query window connected it should connect to that server.
If working disconnected then you will get the pop up.
|||Thank you for your reply, your answer does work nicely. It would seem this would be something you could define a default for. It is taking a little time to get used to the SQL 2005 tools after using SQL 2000 for so long.
If you are a member of Experts-Exchange.com please visit this link and post your answer to receive the allotted points. If after 48 hours or so I have not seen your post there I will post your answer for the benefit of others and close the question in that forum.
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21773295.html
Regards,
Greg
|||Done, haven't answered a question on EE for a while|||EE Saves my bacon from time to time:)
Your blog site is very kewl, you must be a busy person.
Sent an email to your yahoo address Returned Undeliverable.
|||I think this is semi-related to your thread, so I hope it's cool to post this here. If you have a query window in SSMS, and drag and drop one or more script files on it, it prompts you for the database to connect to, for each file you dropped. In 2000 query analyzer, it will automatically connect each file to the same server and database. Do you know of a way to accomplish this in 2005?|||I don't believe so.
No comments:
Post a Comment