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

  • if you don't run with full recovery you can do:

    1. select into some temp table all the data you don't want to delete.

    2. truncate your table.

    3. select into your table the data from the temp table (if you don't have indexes and etc. you can only rename it and in step 2 you can simply drop the table).