Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Channel Islands
    Posts
    2

    Question Unanswered: Multipe Inserts Causes Error - Please Help

    I am currently using ADO to create a recordset, once I have selected my data (1 column called customer - datatype int - about 50,000 of them), I then post a transaction to each cutomer using a stored procedure. I am using a disconnect recordset for the initial ADO recordset and after each run of the store procedure I set everything to closed then nothing. I have plenty of resources available but I still get the following error.

    17066 :
    SQL Server Assertion: File: <S:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
    Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.

    Can anyone help, sorry if this is not infomation I can post more if needed only to be honest I don't what to extra to post.

    As a matter of interest I have also had this error when importing 1.7 millon records with DTS!!

  2. #2
    Join Date
    Sep 2002
    Location
    Channel Islands
    Posts
    2

    Smile Re: Multipe Inserts Causes Error - Please Help

    Have since found out this was due to a hardware issue, it seems that it relates to CPU clocking speeds and or Video cards.

    Have replaced the cpu and motherboard in my case and the problem has not returned, and I have run extensive test and re-tests

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •