>Is there a way to turn off the transaction log in SQL 7.0 via VFP 6.0?
>We are updating a sql table that is causing the transaction log to fill up.
>
>Thanks in advance!
Set the database to "Select Into/bulk copy" in the properties/options tab. This will put you in a non-logged mode for doing bulk loads. Be sure you reset this before you resume production.
If you are having problems in production, check you initial size and growth settings. I usually start my log size at 20-25% of my database size. HTH
Bob Tracy
Never engage in a battle of wits if you're only half armed.