I know how to use BEGIN TRAN before SQL statements in the Query yser
(SQL 2000) and the either COMMIT or ROLLABCK as required.
I have a VB application that will be updating large amounts of data in our
database. My Ideal solution would be to programmatically BEGIN TRAN before
the updates occur and then COMMIT once it has completed but with the option
to rollback if the application runs into unrecoverable trouble.
My questions are:
1.) How do you BEGIN TRAN, COMMIT and ROLLBACK in a stored proc call from VB
2.) When calling BEGIN TRAN ...