>When I think about it. Normally I will simply click on the new query button and the file open which creates the problem...
>
I think I may have found it!
Under Tools/Options..., under Query Execution from the TreeView, drill down to General and check the checkbox for "By default, open new queries in SQLCMD mode". That seems to allow the "New Query" button to work without prompting the connection.
Update! Still doesn't work for open file, though. :(
>
>
>>Do you use "New - Query with Current Connection"? I usually just use cut and paste any more to get around the problem.
>>
>>>I use windows authentication for connecting to SQL Server and I am still prompted with the connection dialog even if I am already connected to the correct database server inside SQL Management Studio 2005.
>>>
>>>
>>>>>Hi gang,
>>>>>
>>>>>This has probably been asked and answered before, but I did a quick search here and didn't find anything.
>>>>>
>>>>>The big thing that I really hate about the new SQL 2005 Management Studio is this: I have a lot of .sql files saved to my hard drive ... such as scripts for StoredProcs, for generating test data, etc. In the old SQL 2000 Query Analyzer, I could open a New Query window, then choose the file to open from the File | Open menu, and it would open the file directly into the New Query window.
>>>>>
>>>>>But now, in Management Studio,
every time I try to open a file, a connection dialog comes up. This is most annoying. Is there a setting somewhere that I need to tweak?
>>>>>
>>>>>TIA,
>>>>>~~Bonnie
>>>>
>>>>I think you may be stuck with it unless you're using Windows Authentication. Hope you find out otherwise, I have a thorough dislike for it, too.