Not that I am aware of. I believe TRUNCATE and SELECT INTO are the only commands that are not logged. You could try shrinking the log file after you update. I have a script I use that shrinks the log file and strips out the empty space. It's a resource hog but does a great job of reclaiming disk space. Let me know if you would like a copy.
Duane -----Original Message----- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:48 PM To: SQL Subject: Update without logging I'm trying to clean up a massive logging table and I'm using update statements in my work. It's all going ok, but the tempDB and log for the table is going crazy. Is there any way to do an update without it being logged or without the tempdb filling to a few hundred meg? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2526 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
