Friday, February 17, 2012

Delete Query

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
>

No comments:

Post a Comment