I have a table that we are using this month for the first time. The table is a bit larger than pretty much all our other tables in use now.
We have the table set to archive off at the end of each month so no other records are written to it.
I noticed that our 08/31/05 archive had exactly 199,000 rows.
Did I hit some sort of limit or is it just by some strange coincidence that there are exactly this many records for the month?
We have a different number of records inserted each day.
I did look up the limits for tables but all I found was limits on the size of the data and numbers of columns etc., I could not find a limit on number of rows/records.
Any help is appreciated.
Wholesale Private Label Internet Access!
http://www.YourOwnISP.com