what if the connection is broken and you can no longer communicate with the SQL Server from the client. I would be unable to issue any further commands What will happen to the records i was adding or updating ???

Chris