Turning off the Log File

[Alex Walter]

Is There any way to stop a database from writing to the log file when you alter the design
of a table.

[Jim Roberts]

If you are referring to the transaction log then the answer is no. However, you can set the database option "Truncate Log on Checkpoint" in the database properties page. This will truncate the transaction log when SQL Server performs a checkpoint (about every minute).
On 1/13/99 3:57:27 PM, Alex Walter wrote:

Never hurts to help,

- JimR

> Is There any way to stop a database from writing to the log file when you
> alter the design
of a table.