>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!
One more time! You could use the sp_dboption stored procedure with SQL Pass Through from inside VFP to set and reset the "Set into/bulk copy" option.
Bob Tracy
Never engage in a battle of wits if you're only half armed.