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 Script Error - Permanent Fix?

I know that you can make the IE script error go away by changing the view of
a database to something other than taskpad, then change it back, but this is
temporary--the error always comes back. Is there a permanent fix?
Unfortunately there is none that I know of short of SQL 2005<g>.
Andrew J. Kelly SQL MVP
"salty" <salty@.discussions.microsoft.com> wrote in message
news:9DA719CA-07DF-49C6-BF62-147D59A7CED3@.microsoft.com...
> I know that you can make the IE script error go away by changing the view
of
> a database to something other than taskpad, then change it back, but this
is
> temporary--the error always comes back. Is there a permanent fix?
>
|||That wasn't the answer I was hoping for... :^(
Thanks for the reply, though.
"Andrew J. Kelly" wrote:

> Unfortunately there is none that I know of short of SQL 2005<g>.

EM in SS2000

In EM when I right-click on a database and choose "view", "taskpad" I get a
list of tables. Under some of the tables, I see the names of indexes that I
recognize but then I also see something like hind_909246294_10A_1A or
_WA_Sys_dtCCreationDate_3631FF56. What are these?
Thanks,
--
Dan D.Those are not indexes. They are auto-creates statistics. See the auto create statistics database
option. You can drop these using DROP STATISTICS, but they were created for a reason in the first
place, so best is most often to leave them.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> In EM when I right-click on a database and choose "view", "taskpad" I get a
> list of tables. Under some of the tables, I see the names of indexes that I
> recognize but then I also see something like hind_909246294_10A_1A or
> _WA_Sys_dtCCreationDate_3631FF56. What are these?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Tibor Karaszi" wrote:
> Those are not indexes. They are auto-creates statistics. See the auto create statistics database
> option. You can drop these using DROP STATISTICS, but they were created for a reason in the first
> place, so best is most often to leave them.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> > In EM when I right-click on a database and choose "view", "taskpad" I get a
> > list of tables. Under some of the tables, I see the names of indexes that I
> > recognize but then I also see something like hind_909246294_10A_1A or
> > _WA_Sys_dtCCreationDate_3631FF56. What are these?
> >
> > Thanks,
> > --
> > Dan D.
>
>

EM in SS2000

In EM when I right-click on a database and choose "view", "taskpad" I get a
list of tables. Under some of the tables, I see the names of indexes that I
recognize but then I also see something like hind_909246294_10A_1A or
_WA_Sys_dtCCreationDate_3631FF56. What are these?
Thanks,
--
Dan D.Those are not indexes. They are auto-creates statistics. See the auto create
statistics database
option. You can drop these using DROP STATISTICS, but they were created for
a reason in the first
place, so best is most often to leave them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> In EM when I right-click on a database and choose "view", "taskpad" I get
a
> list of tables. Under some of the tables, I see the names of indexes that
I
> recognize but then I also see something like hind_909246294_10A_1A or
> _WA_Sys_dtCCreationDate_3631FF56. What are these?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Tibor Karaszi" wrote:

> Those are not indexes. They are auto-creates statistics. See the auto crea
te statistics database
> option. You can drop these using DROP STATISTICS, but they were created fo
r a reason in the first
> place, so best is most often to leave them.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
>
>