Prevent writing to the Transaction Log?

I know this isn't exactly best practice, but is there anyway to perform DELETEs and INSERTs without writing to the transaction log?

Mike

No. The only type of operations that can be minimally logged (in SIMPLE and BULK_LOGGED recovery mode) are Creation and drop of indexes Bulk loading of data Modification of BLOB data SELECT INTO -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ wrote in message news:99b53f54-94e2-44c5-998e-3a66b6bb2966@.discussions.microsoft.com... >I know this isn't exactly best practice, but is there anyway to perform
> DELETEs and INSERTs without writing to the transaction log? >
> Mike >
>