Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

System resource exceeded with linked ODBC MS SQL 2000 table

Discussion in 'Information Technology' started by jrajotte@gmail.com, Jul 28, 2006.

  1. jrajotte@gmail.com

    jrajotte@gmail.com
    Expand Collapse
    Guest

    Hi,

    I have a simple query that reads from a linked Access table a bunch of
    records (300 000) and append to a linked ODBC MS SQL 2000 table. With
    this configuration, I receive the error "System resource exceeded". If
    I replace the linked ODBC table by a linked Access table, it works
    without error and I can append many hundred thousands of records at a
    time.

    Can someone explain me what is happening,
    Tx
     
  2. Loading...

    Similar Threads Forum Date
    Hard Talk The Caste System: Here's Why It's So Repugnant To Sikhi Hard Talk Aug 15, 2016
    Shabad Numbering System New to Sikhism Dec 1, 2015
    Canada India banned the caste system 60 years ago, but it lives on for many in Metro Vancouver Breaking News Oct 11, 2013
    Devanagari as a Writing System for Punjabi: Plus or Minus for Punjabi? Punjab, Punjabi, Punjabiyat Jul 30, 2013
    India India sets up elaborate system to tap phone calls, e-mail Breaking News Jun 20, 2013

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    jrajotte@gmail.com wrote:
    > Hi,
    >
    > I have a simple query that reads from a linked Access table a bunch of
    > records (300 000) and append to a linked ODBC MS SQL 2000 table. With
    > this configuration, I receive the error "System resource exceeded".
    > If I replace the linked ODBC table by a linked Access table, it works
    > without error and I can append many hundred thousands of records at a
    > time.
    >
    > Can someone explain me what is happening,
    > Tx


    That append is being logged on the SQL Server and the transaction log might be
    running out of room. Generally DTS FROM SQL Server is better for bulk moves
    like this because they are not logged. Doing it with append queries you might
    have to break it up into several smaller chunks.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page