Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Question Unanswered: Deleting records from a table without logging to the transaction log

    Hi,

    I need to delete a lot of data (~ 2 million rows from a table)
    and do not want to log it to the transaction log
    Is there a no logging option when running the delete transaction

    Thanks,
    Dave

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    12

    Re: Deleting records from a table without logging to the transaction log

    You should be able to use "truncate table tablename" but this will delete all records in the table. If you don't want to delete them all, consider copying out the ones you want save, then inserting them back in.
    Will

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •