When I think about it. Normally I will simply click on the new query button and the file open which creates the problem...
>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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"