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
Showing posts with label total. Show all posts
Showing posts with label total. Show all posts
Friday, March 9, 2012
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
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
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
Sunday, February 26, 2012
Eliminating Duplicates
I have a table with 580 rows of duplicate on total of 1101 rows. The
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/defaul...kb;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/defaul...kb;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
Eliminating Duplicates
I have a table with 580 rows of duplicate on total of 1101 rows. The
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.
Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/default...b;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.
Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/default...b;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
Eliminating Duplicates
I have a table with 580 rows of duplicate on total of 1101 rows. The
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/default.aspx?scid=kb;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
duplicates are in 3 columns that were supposed to be primary key columns
(Developers forgot to create the primary key in development-production is
OK).
I figured the duplicates with a query but I don't know how to delete them
from the table.
Can anyone help ? Thanks.Hi,
See this:-
http://www.sqlteam.com/item.asp?ItemID=3331
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256
http://support.microsoft.com/default.aspx?scid=kb;en-us;139444
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:DAF8776C-7644-4B3A-83BC-4C6B02FF2607@.microsoft.com...
>I have a table with 580 rows of duplicate on total of 1101 rows. The
> duplicates are in 3 columns that were supposed to be primary key columns
> (Developers forgot to create the primary key in development-production is
> OK).
> I figured the duplicates with a query but I don't know how to delete them
> from the table.
> Can anyone help ? Thanks.
Subscribe to:
Posts (Atom)