Publish your SOP accounting template on your local server. Now that it is published you will need to let everyone know that you have completed your Standard Operating Procedure Template that you want everyone in the company to use for every procedure that is written. That’s it. Standards speed up learning within various industry segments just like SOP Accounting Templates speed up learning what to write. Many business processes share the same characteristics. And while not all business processes are exactly the same, many are similar enough to learn from and model to write your own procedures for your business.
If an error generated in a TRY block causes the state of the current transaction to be invalidated, the transaction is classified as an uncommittable transaction. An error that ordinarily ends a transaction outside a TRY block causes a transaction to enter an uncommittable state when the error occurs inside a TRY block. An uncommittable transaction can only perform read operations or a ROLLBACK TRANSACTION. The transaction cannot execute any Transact-SQL statements that would generate a write operation or a COMMIT TRANSACTION. The XACT_STATE function returns a value of -1 if a transaction has been classified as an uncommittable transaction. When a batch finishes, the Database Engine rolls back any active uncommittable transactions. If no error message was sent when the transaction entered an uncommittable state, when the batch finishes, an error message will be sent to the client application. This indicates that an uncommittable transaction was detected and rolled back.