It was discussed & decided that every insert should be a physical one commited to db. The question was whether to follow Microsoft's recommendation to close the connection after every transaction...

Locks would be freed by commiting the transaction (which has this INSERT/UPDATE stmt) in the stored procedure. The application need not close the connection(after every update) for releasing the locks. Moreover, by default SQL server...