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...
can[vbcol=seagreen]
>
>.
>|||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...[vbcol=seagreen]
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> service pack level
> can|||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),1
3,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

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.
Jeffrey
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
|||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[vbcol=seagreen]
>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...
can
>
>.
>
|||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...[vbcol=seagreen]
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> service pack level
> can
|||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

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

EM Taskpad Error

In the EM, when selecting a few databases I receive an error dialog offering
to debug.
Error Runtime, Line 306, Unspecified
Canceling shows the taskpad view w/out any info.
Any reasons or clues how to repair?
TIA
Sorry, I found my ans. Right-click on the db name, select |View choose
anything except taskpad, then repeat, choose taskpad this time... all is
much better.
Thanks to...
NetBy TelDBA
Chris Wood
and Arron [SQL Server MVP] provided this link
http://www.aspfaq.com/2293
HTH
"JeffP->" wrote:

> In the EM, when selecting a few databases I receive an error dialog offering
> to debug.
> Error Runtime, Line 306, Unspecified
> Canceling shows the taskpad view w/out any info.
> Any reasons or clues how to repair?
> TIA
>
|||Yup, this bug has been around since day 1 and they never bother to fix it.
That is the only way I know of to fix it for a little while anyway.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"JeffP->" <JeffP@.discussions.microsoft.com> wrote in message
news:AB06D182-E42F-4D2E-BD15-ECDDEF17E42E@.microsoft.com...[vbcol=seagreen]
> Sorry, I found my ans. Right-click on the db name, select |View choose
> anything except taskpad, then repeat, choose taskpad this time... all is
> much better.
> Thanks to...
> NetBy TelDBA
> Chris Wood
> and Arron [SQL Server MVP] provided this link
> http://www.aspfaq.com/2293
> HTH
> "JeffP->" wrote:

EM Taskpad Error

In the EM, when selecting a few databases I receive an error dialog offering
to debug.
Error Runtime, Line 306, Unspecified
Canceling shows the taskpad view w/out any info.
Any reasons or clues how to repair?
TIASorry, I found my ans. Right-click on the db name, select |View choose
anything except taskpad, then repeat, choose taskpad this time... all is
much better.
Thanks to...
NetBy TelDBA
Chris Wood
and Arron [SQL Server MVP] provided this link
http://www.aspfaq.com/2293
HTH
"JeffP->" wrote:
> In the EM, when selecting a few databases I receive an error dialog offering
> to debug.
> Error Runtime, Line 306, Unspecified
> Canceling shows the taskpad view w/out any info.
> Any reasons or clues how to repair?
> TIA
>|||Yup, this bug has been around since day 1 and they never bother to fix it.
That is the only way I know of to fix it for a little while anyway.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"JeffP->" <JeffP@.discussions.microsoft.com> wrote in message
news:AB06D182-E42F-4D2E-BD15-ECDDEF17E42E@.microsoft.com...
> Sorry, I found my ans. Right-click on the db name, select |View choose
> anything except taskpad, then repeat, choose taskpad this time... all is
> much better.
> Thanks to...
> NetBy TelDBA
> Chris Wood
> and Arron [SQL Server MVP] provided this link
> http://www.aspfaq.com/2293
> HTH
> "JeffP->" wrote:
>> In the EM, when selecting a few databases I receive an error dialog
>> offering
>> to debug.
>> Error Runtime, Line 306, Unspecified
>> Canceling shows the taskpad view w/out any info.
>> Any reasons or clues how to repair?
>> TIA
>>

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual.
I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tool
s?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual
. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client to
ols?
> In any case, you may need to install SP4 on the client. If it happens on t
he
> server, you need to do an impcat analisys before installing SP4. I would n
ot
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
>

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? Thanks
Is this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks
|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
> > Hi,
> >
> > When I tried to view tables of one my database (sql2000) from Enterprise
> > manger by clicking on Databases --> <database name> --> Tables, it got
> > frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> > close EM and tried several times, it's still the same. How can I
> > troubleshoot? Thanks

EM - question

Hi,
we are using SQL 2000.
When I open the EM, expand the tree for databases, so I see all the
databases.It's possible to make some database groups?
I mean make just group called for example "Jakub" and in this group I will
have all my databases, then next group called "Vrata" and there will be some
other databases ...etc
thanks for answers
JakubUnfortunately, that feature is not available.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Jakub Novak" <jnovak@.memrb.cz> wrote in message
news:u2G$JGn2DHA.3656@.TK2MSFTNGP11.phx.gbl...
Hi,
we are using SQL 2000.
When I open the EM, expand the tree for databases, so I see all the
databases.It's possible to make some database groups?
I mean make just group called for example "Jakub" and in this group I will
have all my databases, then next group called "Vrata" and there will be some
other databases ...etc
thanks for answers
Jakub

EM - question

Hi,
we are using SQL 2000.
When I open the EM, expand the tree for databases, so I see all the
databases.It's possible to make some database groups?
I mean make just group called for example "Jakub" and in this group I will
have all my databases, then next group called "Vrata" and there will be some
other databases ...etc
thanks for answers
JakubUnfortunately, that feature is not available.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Jakub Novak" <jnovak@.memrb.cz> wrote in message
news:u2G$JGn2DHA.3656@.TK2MSFTNGP11.phx.gbl...
Hi,
we are using SQL 2000.
When I open the EM, expand the tree for databases, so I see all the
databases.It's possible to make some database groups?
I mean make just group called for example "Jakub" and in this group I will
have all my databases, then next group called "Vrata" and there will be some
other databases ...etc
thanks for answers
Jakub