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

  • [font="Verdana"]I'm guessing we need some idea of why you need to delete records without having the delete logged. If we understand the why, we may be able to give you more options.

    You can use truncate table to delete every record, but only in the case where no other table has a referential constraint pointing to that table.

    [/font]