I need to limit the size of a table by number of records, not by file size. I haven't been able to find any statements that show how to do this. Any help would be appreciated...Thanks!
You could do it with an insert trigger. You could either rollback any transaction that would cause the row limit to exceeded, or you could delete the oldest/inactive records to make room for the new ones.