Home Forums SQL Server 2005 T-SQL (SS2K5) delete records in sql without entry in transaction log RE: delete records in sql without entry in transaction log

  • We also have a situation where periodically we are need to bulk-delete an entire table (about 3 million records) and bulk-reload it from a file we receive from elsewhere. At this point it looks like the TRUNCATE solution will work for us. Unless somebody has a better idea.

    (Also DROP TABLE with a re-creation is another option.)