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
StarNamer
SSCrazy Eights
Points: 8744
More actions
February 3, 2009 at 6:42 am
#937082
If you are deleting an entire table you could use TRUNCATE TABLE, which only logs the page deallocations rather than having an entry for each row deleted. I'm not aware of any way to do deletions without any transaction logging at all.
Derek