Posted by Doug on 03/01/06 02:56

why do you have 7.5 million tables in a single database named
core???????

and, you are printing something from each one??????

perhaps you might be better served to have ONE or two core tables?

If nothing else, delete or rename some of them. If nothing else,
create yet another new table name of the ones that have been processed,
and quit processing them over and over again.

if you must process them all each time, then use "top 10,000" to only
grab 10,000 at a time, and keep track of hte ones you ahve done in a
temp table for that particular run, so you don't do them twice.

[Back to original message]