In SQL 2000, you cannot give anyone else permission to truncate your table.

I have always thought this was a bit strange, since truncate is so much

faster. You can grant someone...