Enterprise manager

Hi,
Does anyone know wich stored procedure enterprise manager call
when listing databases?
Marcin S.Try using sp_helpdb ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Marcin S." wrote:

> Hi,
> Does anyone know wich stored procedure enterprise manager call
> when listing databases?
>
> --
> Marcin S.|||Hi,
I don't thinks it uses this SP becouse i does not list all DB:s
Marcin S.
"Jens Sü?meyer" wrote:
> Try using sp_helpdb ?
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Marcin S." wrote:
>|||Hi,
I don't thinks it uses this SP becouse i does not list all DB:s
Marcin S.
"Jens Sü?meyer" wrote:
> Try using sp_helpdb ?
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Marcin S." wrote:
>|||sp_helpdb lists all the databases you have access to. Enterprise Manager
doesn't use sp_helpdb, it just uses master..sysdatabases directly.
Jacco Schalkwijk
SQL Server MVP
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4343496D-4978-44B0-B0C9-1625555ED99A@.microsoft.com...
> Hi,
> I don't thinks it uses this SP becouse i does not list all DB:s
>
> --
> Marcin S.
>
> "Jens Smeyer" wrote:
>|||Hi,
Just run the SQL Profiler and click the databases in Eneterprise manager.
You could see all the Queries and stored procedures fired to get the result.
Thanks
Hari
SQL Server MVP
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4CB59A10-BA8A-4D96-AEAF-EEFE1BB39FBE@.microsoft.com...
> Hi,
> Does anyone know wich stored procedure enterprise manager call
> when listing databases?
>
> --
> Marcin S.