Cannot be done, certainly not in 2000 (and for sure 7). If you could do this, you would effectively be rendering backups and data integrity useless.
There are ways you can cut down the amount of info logged but using SELECT INTO, BCP. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 02:48 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:2527 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
