Although you can't turn off the logging, you might get some speed or tempdb usage improvements if you first drop all your indexes (except the PK), and make sure the PK is not a clustered index. Then just add/recreate/cluster the indexes later.
-Ken On 7/26/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > 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:2528 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
