This may be a newbie type question, but...
I have a VB program that does mass loads to certain SQL databases. The
programs are set to empty the tables first, then do massive loads.
However, I have run into an issue that when the program attempts to delete
the rows first (about 250,000), about 1/3 of the way through, I get a log
file full error. I then have to Truncate the log (with the No_Log option)
and restart the program. It takes two attempts before the program finally
finishes the delete. The delete is a simple mass delete like this:
DELETE FROM MYTABLE
Is there any way to issue this SQL statement without the resulting deletes
being logged. I am using VBSQL to hit the SQL server from VB. I do not do
a Begin/End Transaction.
Any help would be appreciagted.
****InterWave - "Your Total Solution Provider"****