EXEC sp_readerrorlog 1;

Hi,

EXEC sp_readerrorlog 1; usually gives me errors from days ago without the errors from today. When I look at the error logs in the Enterprise Manager, the first errors I see are indeed the ones appearing in my list which I retrieved from the sp_readerrorlog 1; but when I scroll down to the bottom, I can see the logs from today.

So, why is it that the logs from today do not appear in my list pulled from sp_readerrorlog 1; ?

I have this problem on multiple SQL Servers 2000 Enterprise Edition

I hope I'm not the only one with this problem.

Many thanks!

Regards,

Worf

First, be aware that sp_readerrorlog resides in the 'undocumented realm', so it's on use at your own risk policy.

sp_readerrorlog 1 says to read logfile #1, which is the file previous to the currently logfile.
(the default file# is 0)

File 1 may contain items from today (if recently cycled), yesterday or weeks or months ago, depending on how long the current log (file 0) has been active and not cycled.

Are you sure that you're really asking for what you think you're asking for, since you say you want 'the newest archived log'? I'd guess that it's most likely that sp_readerrorlog 1 won't show any logs from the current day in most cases.

/Kenneth

sql

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

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"