Enumerate/list data sources and their connection strings

I was wondering ..
Is there an easy way to enumerate all data sources and their configuration
parameters (e.g. connection strings) in a reporting services database ?
Thanks a bunch.Isn't there really anybody here on the forum with a suggestion how to
achieve this or is it actually so trivial that I don't deserve a reply ;) ?

Enterprise Manager very slowly

Hi,
Is there any parameters to configure to improve the performance in the
Enterprise Manager ? I have installed 7 small databases but when I click in
the "Databases" option, for example, I need to wait for several seconds (I
don´t think this is right). There are other options with the same problem.
It´s occur and my two machines (and I already see this in other machines),
the first running Windows 2003 Server Standard RC2 and the second running
Windows XP Professional, both with SQL Server 2000 - SP3.
Any suggest ?
Vitor Mauricio de N. Silva
Rio de Janeiro - BrazilVitor
Have you check odbc trace is running?
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>|||Perfect. I had some databases with the option AUTO CLOSE clicked. After
changed everything works fine.
Thanks,
Vitor Mauricio de N. Silva
Rio de Janeiro - Brazil
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>

Entering parameters resets other parameters

I am having a problem with reports where, after a parameter is changed, it
will remove the currently displayed report (replacing it with white) and on
some occassions reset some of the other parameters (even though there are no
dependencies). Is there some way to disable the refresh so that only
clicking "View Report" will change the report displayed?Has anyone else experienced this? We see the same thing and I would really
like to get rid of this behavior.
Thank you!
Jon
"Kyle" <Kyle@.discussions.microsoft.com> wrote in message
news:53AAA6CD-0B51-4879-A641-C580CD9819D6@.microsoft.com...
>I am having a problem with reports where, after a parameter is changed, it
> will remove the currently displayed report (replacing it with white) and
> on
> some occassions reset some of the other parameters (even though there are
> no
> dependencies). Is there some way to disable the refresh so that only
> clicking "View Report" will change the report displayed?