Database dropdown, Query Analyzer

I didn't see my previous post in the last half hour, so reposting again.
Ok. Whenever I have to switch to a different database in my DEV server, if I
click the dropdown box, it takes for ever to show the list of databases on
that server.I tried few things, but didn't work. I truncated the Log files,
Shrink database & log files. Any clues how this can be rectified. Or any
pointers or corners I haven't looked at.Have you looked to see if your request is blocked? Sometimes the system
tables can be blocked during database changes.
"S" <S@.discussions.microsoft.com> wrote in message
news:5015D71C-05CA-47F5-9950-C63C25DE830B@.microsoft.com...
>I didn't see my previous post in the last half hour, so reposting again.
> Ok. Whenever I have to switch to a different database in my DEV server, if
> I
> click the dropdown box, it takes for ever to show the list of databases on
> that server.I tried few things, but didn't work. I truncated the Log
> files,
> Shrink database & log files. Any clues how this can be rectified. Or any
> pointers or corners I haven't looked at.
>|||This happens every time I try to switch to a different database. I have
checked for open/ blocked transactions but there are none.
"Danny" wrote:

> Have you looked to see if your request is blocked? Sometimes the system
> tables can be blocked during database changes.
>
> "S" <S@.discussions.microsoft.com> wrote in message
> news:5015D71C-05CA-47F5-9950-C63C25DE830B@.microsoft.com...
>
>|||Check to ensure the 'auto close' option is off in all databases. This
option can elongate database enumeration.
Hope this helps.
Dan Guzman
SQL Server MVP
"S" <S@.discussions.microsoft.com> wrote in message
news:5015D71C-05CA-47F5-9950-C63C25DE830B@.microsoft.com...
>I didn't see my previous post in the last half hour, so reposting again.
> Ok. Whenever I have to switch to a different database in my DEV server, if
> I
> click the dropdown box, it takes for ever to show the list of databases on
> that server.I tried few things, but didn't work. I truncated the Log
> files,
> Shrink database & log files. Any clues how this can be rectified. Or any
> pointers or corners I haven't looked at.
>|||Did you run a Profiler trace, like Kalen suggested, catch the TSQL submitted
by QA and execute that
same TSQL from a QA query Window?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"S" <S@.discussions.microsoft.com> wrote in message
news:5015D71C-05CA-47F5-9950-C63C25DE830B@.microsoft.com...
>I didn't see my previous post in the last half hour, so reposting again.
> Ok. Whenever I have to switch to a different database in my DEV server, if
I
> click the dropdown box, it takes for ever to show the list of databases on
> that server.I tried few things, but didn't work. I truncated the Log files
,
> Shrink database & log files. Any clues how this can be rectified. Or any
> pointers or corners I haven't looked at.
>|||I found the problem and fixed it. Thanks for your time for helping me to
resolve this.
This also helped me.
[url]http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=206193[
/url]
"Tibor Karaszi" wrote:

> Did you run a Profiler trace, like Kalen suggested, catch the TSQL submitt
ed by QA and execute that
> same TSQL from a QA query Window?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "S" <S@.discussions.microsoft.com> wrote in message
> news:5015D71C-05CA-47F5-9950-C63C25DE830B@.microsoft.com...
>
>|||Can you say what the problem was? The link doesn't work if you're not a memb
er...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"S" <S@.discussions.microsoft.com> wrote in message
news:F510727E-F5E7-4545-9BD4-3169D600A440@.microsoft.com...[vbcol=seagreen]
>I found the problem and fixed it. Thanks for your time for helping me to
> resolve this.
> This also helped me.
> http://www.sqlservercentral.com/for...=20619
3
> "Tibor Karaszi" wrote:
>