EM won't display databases

After adding 6 databases to a server for a total of 16
databases, my Enterprise Manager won't display databases
(the databases just disappeared).
However, DBArtisan and Query Analyzer work fine. Both can
display the databases. Is there a limit on the total
number of databases EM can display? Or is this a bug in
EM?
TIA.
JeffreyJeff,
EM surely can handle 16.Whats the SQLServer version and service pack level
of this EM?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey|||2000 SP3a. Is it possible that SP3a is the problem?
Thanks.
>--Original Message--
>Jeff,
>EM surely can handle 16.Whats the SQLServer version and
service pack level
>of this EM?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
>news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
>> After adding 6 databases to a server for a total of 16
>> databases, my Enterprise Manager won't display databases
>> (the databases just disappeared).
>> However, DBArtisan and Query Analyzer work fine. Both
can
>> display the databases. Is there a limit on the total
>> number of databases EM can display? Or is this a bug in
>> EM?
>> TIA.
>> Jeffrey
>
>.
>|||Jeff,
Not sure.Try reinstalling the relevant MDAC.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@.discussions.microsoft.com> wrote in message
news:596401c42d60$3dcafcc0$a601280a@.phx.gbl...
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> >--Original Message--
> >Jeff,
> >
> >EM surely can handle 16.Whats the SQLServer version and
> service pack level
> >of this EM?
> >
> >--
> >Dinesh
> >SQL Server MVP
> >--
> >--
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
> >news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> >> After adding 6 databases to a server for a total of 16
> >> databases, my Enterprise Manager won't display databases
> >> (the databases just disappeared).
> >>
> >> However, DBArtisan and Query Analyzer work fine. Both
> can
> >> display the databases. Is there a limit on the total
> >> number of databases EM can display? Or is this a bug in
> >> EM?
> >>
> >> TIA.
> >>
> >> Jeffrey
> >
> >
> >.
> >|||Jeff -
There are several differences in the way that Artisan and Enterprise
Manager enumerate the list of DBs-
Enterprise Manager runs 'exec sp_MSdbuseraccess N'db', N'%'' to get a list,
and Artisan runs 'SELECT name,status,' ',CONVERT(char(10),crdate,101)+'
'+SUBSTRING(CONVERT(char(20),crdate,0),13,7) FROM master.dbo.sysdatabases
ORDER BY 1'
There important diff here is permissions. To test, run exec
sp_MSdbuseraccess N'db', N'% in Query Analyzer as the same user you connect
using EM. I am guessing that the list will be short the same way EM is. Then
you need to fix your permissions.
Let me know if that does not help.
Craig
ccarl@.mcafee.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey