Excessive Database Polling in Enterprise Manager

I'm using Enterprise Manager to connect to the SQL server space on my shared Web hosting server. Because, however, that there are literally about a thousand other databases on the server, each time I connect, I'm forced to wait ten to fifteen minutes whil
e Enterprise Manager polls the server for all the databases.
Is there a way to force Enterprise Manager into connecting my database only and ignoring all others?
Thanks in advance.
Okies, problem solved. I just ended up using the database management tools built in to Web Matrix.

exception_int_divied_by_zero..

You mean, you are getting this error from Enterprise Manager? If so, could
you try the same from Enterprise Manager on another machine?
What exactly are you trying to do? You can probably do the same using
scripts from Query Analyzer.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Chung" <chung@.utaxhk.com.hk> wrote in message
news:%238S2Dw%23bFHA.584@.TK2MSFTNGP15.phx.gbl...
Hi all, once I try to change to the design mode of any table, an error
message "Exception_Int_Divided_By_Zero" display, what does this mean? And
alos, when I try to generate SQL script, drop a view, use DTS to export
data, I also receive this error message, any idea how to solve it?I found that this error is associates with the database, not with the
Enterprise Management. Because not all of database has these error, only one
database. And even I backup, and restore it, the error still there. Without
EM, how can I generate the SQL script of the database? and copy data from
the database?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> glsD:%23HfYeNAcFHA.3184@.TK2MSFTN
GP15.phx.gbl...
> You mean, you are getting this error from Enterprise Manager? If so, could
> you try the same from Enterprise Manager on another machine?
> What exactly are you trying to do? You can probably do the same using
> scripts from Query Analyzer.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Chung" <chung@.utaxhk.com.hk> wrote in message
> news:%238S2Dw%23bFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi all, once I try to change to the design mode of any table, an error
> message "Exception_Int_Divided_By_Zero" display, what does this mean? And
> alos, when I try to generate SQL script, drop a view, use DTS to export
> data, I also receive this error message, any idea how to solve it?
>
>
>|||Sounds more like either your connection, API, or database environment
settings...like SET NUMERIC_ROUNDABORT or SET ARITHABORT. Check your
database properties.
Another possibility would be that your client tools have been corrupted.
Did you install the Beta 1 for SQL Server 2005? There was an MDAC 9 Beta 1
that was included that caused all sorts of issues with SQL Server 2000
tools. You basically have to do a file replace and registry clean to clear
everything off. A new download of an older MDAC won't fix anything becuase
version 9 is newer, the MDAC will not deploy.
Sincerely,
Anthony Thomas
"Chung" <chung@.utaxhk.com.hk> wrote in message
news:u$cDkLLcFHA.3120@.TK2MSFTNGP12.phx.gbl...
I found that this error is associates with the database, not with the
Enterprise Management. Because not all of database has these error, only one
database. And even I backup, and restore it, the error still there. Without
EM, how can I generate the SQL script of the database? and copy data from
the database?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com>
glsD:%23HfYeNAcFHA.3184@.TK2MSFTNGP15.phx.gbl...
> You mean, you are getting this error from Enterprise Manager? If so, could
> you try the same from Enterprise Manager on another machine?
> What exactly are you trying to do? You can probably do the same using
> scripts from Query Analyzer.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Chung" <chung@.utaxhk.com.hk> wrote in message
> news:%238S2Dw%23bFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi all, once I try to change to the design mode of any table, an error
> message "Exception_Int_Divided_By_Zero" display, what does this mean? And
> alos, when I try to generate SQL script, drop a view, use DTS to export
> data, I also receive this error message, any idea how to solve it?
>
>
>

EXCEPTION_ACCESS_VIOLATION

Hi,
using the SQL Server enterprise manager I try to creat a 'INSTEAD
OF'-trigger on a view. When I try to apply changes I get the error
EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
error is about? I've found almost no info using google.
//Magnus
These are most often bus in SQL Server (possibly data corruption, but not likely in this scenario).
If you didn't find anything on KB and you are current on service pack, I suggest you open a case
with MS.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in message
news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
> error is about? I've found almost no info using google.
> //Magnus
|||Hi,Tibor
I am sure you meant bug instead of bus
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> These are most often bus in SQL Server (possibly data corruption, but not
likely in this scenario).
> If you didn't find anything on KB and you are current on service pack, I
suggest you open a case
> with MS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
this
>
|||:-)
Thanks for catching that, Uri.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:uwE$NLFsEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,Tibor
> I am sure you meant bug instead of bus
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> likely in this scenario).
> suggest you open a case
> message
> this
>
|||Create it with QA.
Also see if you can create it from another EM client ..
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> error is about? I've found almost no info using google.
> //Magnus

EXCEPTION_ACCESS_VIOLATION

Hi,
using the SQL Server enterprise manager I try to creat a 'INSTEAD
OF'-trigger on a view. When I try to apply changes I get the error
EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
error is about? I've found almost no info using google.
//MagnusThese are most often bus in SQL Server (possibly data corruption, but not likely in this scenario).
If you didn't find anything on KB and you are current on service pack, I suggest you open a case
with MS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in message
news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
> error is about? I've found almost no info using google.
> //Magnus|||Hi,Tibor
I am sure you meant bug instead of bus :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> These are most often bus in SQL Server (possibly data corruption, but not
likely in this scenario).
> If you didn't find anything on KB and you are current on service pack, I
suggest you open a case
> with MS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message
> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> > Hi,
> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
> > OF'-trigger on a view. When I try to apply changes I get the error
> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> > error is about? I've found almost no info using google.
> >
> > //Magnus
>|||:-)
Thanks for catching that, Uri.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:uwE$NLFsEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,Tibor
> I am sure you meant bug instead of bus :)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> These are most often bus in SQL Server (possibly data corruption, but not
> likely in this scenario).
>> If you didn't find anything on KB and you are current on service pack, I
> suggest you open a case
>> with MS.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
> message
>> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
>> > Hi,
>> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
>> > OF'-trigger on a view. When I try to apply changes I get the error
>> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
> this
>> > error is about? I've found almost no info using google.
>> >
>> > //Magnus
>>
>|||Create it with QA.
Also see if you can create it from another EM client ..
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> error is about? I've found almost no info using google.
> //Magnus

EXCEPTION_ACCESS_VIOLATION

Hi,
using the SQL Server enterprise manager I try to creat a 'INSTEAD
OF'-trigger on a view. When I try to apply changes I get the error
EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what thi
s
error is about? I've found almost no info using google.
//MagnusThese are most often bus in SQL Server (possibly data corruption, but not li
kely in this scenario).
If you didn't find anything on KB and you are current on service pack, I sug
gest you open a case
with MS.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in mess
age
news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what t
his
> error is about? I've found almost no info using google.
> //Magnus|||Hi,Tibor
I am sure you meant bug instead of bus
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> These are most often bus in SQL Server (possibly data corruption, but not
likely in this scenario).
> If you didn't find anything on KB and you are current on service pack, I
suggest you open a case
> with MS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message
> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
this[vbcol=seagreen]
>|||:-)
Thanks for catching that, Uri.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:uwE$NLFsEHA.1816@.TK2MSFTNGP09.phx.gbl.
.
> Hi,Tibor
> I am sure you meant bug instead of bus
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> likely in this scenario).
> suggest you open a case
> message
> this
>|||Create it with QA.
Also see if you can create it from another EM client ..
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> error is about? I've found almost no info using google.
> //Magnus

Exception Error while exporting to Excel

Hello,
I have a report that runs ok at the report manager. However, when I try to
export it to excel
I receive the following error message. Any ideas?
Thank you.
CD
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Item has already been added. Key in dictionary: "20" Key being
added: "20"
----
--
Microsoft Reporting ServicesDo you have a matrix in your report? Does the matrix has subtotals?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DC" <DC@.yahoo.com> wrote in message
news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
>
> Hello,
> I have a report that runs ok at the report manager. However, when I try to
> export it to excel
> I receive the following error message. Any ideas?
> Thank you.
> CD
> Reporting Services Error
> ----
--
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Item has already been added. Key in dictionary: "20" Key being
> added: "20"
> ----
--
> --
> Microsoft Reporting Services
>|||Yes, I do have a matrix report which has subtotals.
CD
"Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> Do you have a matrix in your report? Does the matrix has subtotals?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "DC" <DC@.yahoo.com> wrote in message
> news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> >
> >
> > Hello,
> > I have a report that runs ok at the report manager. However, when I try
to
> > export it to excel
> > I receive the following error message. Any ideas?
> >
> > Thank you.
> > CD
> >
> > Reporting Services Error
> ----
> --
> > --
> >
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Item has already been added. Key in dictionary: "20" Key being
> > added: "20"
> >
> ----
> --
> > --
> > Microsoft Reporting Services
> >
> >
>|||Here comes another bug. If you have a matrix with subtotals, you might
experience some difficulty while exporting reports to excel.
Here is the procedure I followed:
-Get rid of the total column.
-Deploy the report, check if export works.
-Put it back in.
-Deploy the report, check if export works.
When I apply column color changes it failed, and gave me the error message.
Even without color I am happy.
Regards,
Cem
"DC" <DC@.yahoo.com> wrote in message
news:eki3H7AnEHA.3628@.TK2MSFTNGP09.phx.gbl...
> Yes, I do have a matrix report which has subtotals.
> CD
>
> "Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
> news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> > Do you have a matrix in your report? Does the matrix has subtotals?
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "DC" <DC@.yahoo.com> wrote in message
> > news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> > >
> > >
> > > Hello,
> > > I have a report that runs ok at the report manager. However, when I
try
> to
> > > export it to excel
> > > I receive the following error message. Any ideas?
> > >
> > > Thank you.
> > > CD
> > >
> > > Reporting Services Error
> >
> ----
> > --
> > > --
> > >
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Item has already been added. Key in dictionary: "20" Key
being
> > > added: "20"
> > >
> >
> ----
> > --
> > > --
> > > Microsoft Reporting Services
> > >
> > >
> >
> >
>

Excel Import Identity Error

I am trying to import from an Excel Worksheet in the Enterprise Manager. I run through the wizard, and in transformations I have the Enable Identity Insert box checked, but when I run the import I get the following error:
Error at Destination for Row number 13880. Errors so far in this task: 1.
The statement has been terminated.
Cannot insert the value NULL into column 'ID', table 'CCReport.ITPSG.CCSPEND'; column does not allow nulls.
INSERT fails.

There are only 13881 rows, and I don't see anything in 13880 that is any different than the ones before it. Any ideas?try importing into the database first with out enabling the identity column, once it's imported then you can debug the data as well as re-populate the original table by doing any data manupulation.
" insert into originaltable
select columns from importedRawDatatable"