We truncate a couple of our tables at the end of each night and have never experienced problems so far. Our transaction logs haven't grown to a huge size but then we do dump the transaction log every night as well.


------------
Tommy at 3/8/01 5:32:57 PM

I frequently have tables that I want to empty and refill. I thought I read somewhere that trucating was a bad idea, example:

Truncate table tblFruits

A bad idea because of something to do with the log? I'm a beginner so I don't understand transaction processing very well, or logs.

Is it better to delete the table and rebuild it in code before you add the values?