It's called Memo Bloat. See
http://www.craigberntson.com/Articles/kb008.htmThe ideal blocksize depends on what you are storing.
>We are using a table which has an FPT file whose normal size is 45mb - every now and then it suddenly expands to over 2GB
>
>Any ideas why?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer