Andrea ... MSDE Error ! ... Contd ...

Hi,
I checked the links, you suggested me to research on this error “Unknown
token received from SQL Server”.
I am trying to insert 8-10 million rows in the table. I am using a while
loop to insert the row into a single table and not using cursor (Website
suggested to use LOCAL FAST FORWARD). The process was running smooth for 4.3
million rows inserted.
I am using a field VARBINARY(20) and the other fields are VARCHAR, TINYINT &
DATETIME if that helps.
Please advice,
David
hi David,
"David" <David@.discussions.microsoft.com> ha scritto nel messaggio
news:DBFF3C8B-81F2-4655-B645-3CD21B679B84@.microsoft.com
> Hi,
> I checked the links, you suggested me to research on this error
> “Unknown token received from SQL Server”.
> I am trying to insert 8-10 million rows in the table. I am using a
> while loop to insert the row into a single table and not using cursor
> (Website suggested to use LOCAL FAST FORWARD). The process was
> running smooth for 4.3 million rows inserted.
> I am using a field VARBINARY(20) and the other fields are VARCHAR,
> TINYINT & DATETIME if that helps.
> Please advice,
> David
perhaps break your transaction in smaller transactions every n rows you have
to insert...
say every 50,000 rows...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply