2005 Management Studio on Vista Open Dialog can take ages ..

This lengthy pause only seems to happen in SSMS and not all apps. For example
it doesn't happen in Word 2007.

I could drag and drop but I'm sure everyone would agree this sort of pause
is unacceptable.

Anybody else?



"Erland Sommarskog" wrote:

> Devious Devil (DeviousDevil@discussions.microsoft.com) writes:
> > Quite regularly when using Management Studio (SP2) on Vista Business SP1
> > when I try to open a script file (either Ctrl-O or using toolbar) the open
> > dialog appears but all the icons, buttons, list portion are blank and
> > unuseable.
> >
> > After about 10-20 seconds the open dialog refreshes and is drawn
> > correctly. This is most annoying when this happens.
> >
> > Has anybody else had this issue?
> >
> > P.S I'm NOT running Management Studio with admin privileges.
>
> And it only happens from SSMS, and no other program? Particularly no
> other program that uses that Open dialog?
>
> I don't seem to have that problem, but I've noticed that there are
> other Open dialogs in Vista that are painful, particularly those that
> show a directory tree.
>
> A workaround is to locate the file you want to open through Explorer and
> then drag onto Mgmt Studio.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>
 >> Stay informed about: 2005 Management Studio on Vista Open Dialog can take ages .. 

> I could drag and drop but I'm sure everyone would agree this sort of pause
> is unacceptable.

That would be probably be true if other people were experiencing this same
symptom. Like Erland, I am not. Likewise, if it were happening across all
applications, then it's something you could tie to Windows or your specific
environment. But since that's not true either, I don't know what anyone can
possibly suggest for you.

Maybe there is an item in your MRU list (or the last folder you looked at)
for SSMS that is located on a network device that is no longer connected, or
a USB drive that is unplugged, or a DVD that is no longer in the drive, or
on a network share that is slow or that you are no longer allowed to access.
When the open dialog finally opens, where is it located? SSMS remembers the
last place you opened from. So maybe try waiting for the open dialog,
moving to another place (e.g. C:\), actually opening any .sql or .txt file,
and then you should find that the NEXT time you launch the File|Open dialog,
it will be faster.

If that doesn't solve anything, then unless you can show Microsoft exactly
how to reproduce the problem, they are not likely going to be aware of
anything they can "fix"... and even if there were something to fix, it would
take plenty of time for that fix to get into your hands, so you will need
some workaround in the meantime, or gain some patience for the delay, or
keep seeking the source of the problem.
 >> Stay informed about: 2005 Management Studio on Vista Open Dialog can take ages .. 

Hi,

I have been been patient and I do wait for it when it happens - obviously.
Having to open explorer windows to the location of the files each time and
dragging and dropping might be quick when I'm using a lot of files from the
same location but ultimately it is going to still be a problem.

All the files in the recent list are on my local machine. When the open
dialog is finally shown it does remember the last location correctly.

I'm sure you didn't mean to but the response came across very much like
"well me and the other guy who responded don't have the problem therefore it
is definitely not a SSMS problem". Intermittent problems are always the
hardest to pin down (I know as develop software).

Much as I like MS stuff it wouldn't be the first time that something like a
Service Pack, Windows update screwed something up.



"Aaron Bertrand [SQL Server MVP]" wrote:

> > I could drag and drop but I'm sure everyone would agree this sort of pause
> > is unacceptable.
>
> That would be probably be true if other people were experiencing this same
> symptom. Like Erland, I am not. Likewise, if it were happening across all
> applications, then it's something you could tie to Windows or your specific
> environment. But since that's not true either, I don't know what anyone can
> possibly suggest for you.
>
> Maybe there is an item in your MRU list (or the last folder you looked at)
> for SSMS that is located on a network device that is no longer connected, or
> a USB drive that is unplugged, or a DVD that is no longer in the drive, or
> on a network share that is slow or that you are no longer allowed to access.
> When the open dialog finally opens, where is it located? SSMS remembers the
> last place you opened from. So maybe try waiting for the open dialog,
> moving to another place (e.g. C:\), actually opening any .sql or .txt file,
> and then you should find that the NEXT time you launch the File|Open dialog,
> it will be faster.
>
> If that doesn't solve anything, then unless you can show Microsoft exactly
> how to reproduce the problem, they are not likely going to be aware of
> anything they can "fix"... and even if there were something to fix, it would
> take plenty of time for that fix to get into your hands, so you will need
> some workaround in the meantime, or gain some patience for the delay, or
> keep seeking the source of the problem.
>
>
 >> Stay informed about: 2005 Management Studio on Vista Open Dialog can take ages ..