>SQL-Server seems to be logging everything, even for data retrieval. We would like to shut off logging but cannot seem to find how to do this. Oracle, Ingres, DB2 seems to allow you to run queries or perform updates without logging. How do we shut this off for SQL-Server?
>
>Steve
You mean the transaction log? You can set it off by using the Enterprise Manager and checking the box "Truncate Log on checkpoint" or by issuing the following in your statements:
USE master
EXEC sp_dboption 'mydatabase', 'trunc. log on chkpt.', 'TRUE'
HTH