Can anyone help me with this error? I am trying to delete several
 thousand records at a time, but for some reason I continue to get the
 following error. I just applied SP3a for SQL2K hoping that would fix the
 problem, but it has not. Thanks in advance.
 delete [GA_SingleFamily] from (select top 500 * from [GA_SingleFamily]) as
 stuff Where [GA_SingleFamily].ml = stuff.ml
 Event Type: Error
 Event Source: MSSQLSERVER
 Event Category: (2)
 Event ID: 17055
 Date: 10/6/2003
 Time: 12:08:48 PM
 User: N/A
 Computer: DATASERVERA
 Description:
 17066 :
 SQL Server Assertion: File: <recbase.cpp>, line=1378
 Failed Assertion = 'm_offBeginVar < m_SizeRec'.
 --
 Doug Threewittdelete [GA_SingleFamily]
from
[GA_SingleFamily]
inner join
(select top 500 ml from [GA_SingleFamily]) as stuff --(don't use * if you
only want 1 col)
on [GA_SingleFamily].ml = stuff.ml
jobi
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:euXQhONjDHA.548@.TK2MSFTNGP11.phx.gbl...
> Can anyone help me with this error? I am trying to delete several
> thousand records at a time, but for some reason I continue to get the
> following error. I just applied SP3a for SQL2K hoping that would fix the
> problem, but it has not. Thanks in advance.
> delete [GA_SingleFamily] from (select top 500 * from [GA_SingleFamily]) as
> stuff Where [GA_SingleFamily].ml = stuff.ml
>
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 10/6/2003
> Time: 12:08:48 PM
> User: N/A
> Computer: DATASERVERA
> Description:
> 17066 :
> SQL Server Assertion: File: <recbase.cpp>, line=1378
> Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>
> --
> Doug Threewitt
>
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment