settings 2000

[fmardani]

What is the option to set in sql2k so that the transaction logs get truncated automatically?
And also should I set the auto shrink check box checked in options of the database properties?
Thanks

 

[nigelrivett]

Set the recovery model to simple.

If you want it to shrink then yes. Usually it is best not to otherwise the database could continually shrink and grow which is very resource intensive.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.