One of our clients had a program crash while the programm was inserting a bunch of data. Although the programm hadn't run to the point where the commit would have been executed, the data is still there [SA 12.0.1].
So I wonder if there is a connection option triggering a commit it the connection is closed, similar to that option setting in ISQL. I searched the help and checked sa_conn_options, but to no avail. Did I overlook something, or is there another explanation?
asked 31 Jul '12, 09:57