How can I turn off the transaction logging?

What do you mean by turning off logging? Almost everything goes to the
transaction log in SQL Server. If your issue is Log getting bigger and
bigger, set your database to simple recovery model. Check BOL for recovery
model.

HTH
Nitin

Show quoteHide quote

(a) WHY?  Do you not care about your data?  Why are you using a database?

(b) you can't, completely.  You can minimize it using:

ALTER DATABASE dbname SET RECOVERY SIMPLE

However, this severely limits your ability to repair your foot after you
shoot it off...



Show quoteHide quote

Delete Without Writing To Transaction Log
clustered index on a identity field
ROWS with null values getting truncated.
Dynamic order by case expression problem
Generating an Index