USE \\server\abc\table1 i=1 DO WHILE i < 10000 INSERT INTO table1 (field1) VALUES ("abcde") i = i + 1 EnddoNow when doing the SQL insert loop, plug the network cable off (simulating network link error) for a while and plug it then back. Start above code again -> errors within INSERT INTO: