> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I think my 'reasonable' # of extents must be higher than
> yours Jacques. :)
I agree that having a datafile autoextend is better than having a job die. On the other hand a poorly written job that runs amuck can be stopped before creating too much damage if you set limits on your datafile sizes.
But yes, autoextend definitely has its uses.
As far as my suggested maximum of 1000 extents: some people give me grief about that. I have worked mostly in development environments and so I might be out of touch. But 1000 extents should be plenty for anybody. When is the last time you had to drop a table with 10000 extents, and have the developer looking over your shoulder tell you "In Access when you drop a table it's instantaneous?"
