SPCOMMITONRETURN

Commits work done by a stored procedure when it returns to the calling application.
Restriction: Applies to .NET applications only.

Syntax:

SPCOMMITONRETURN

Properties:

Default: None

Dependencies:

To use SPCOMMITONRETURN, you must set DBMAN=ADO.

Scope:

Used at compile time: Yes
Behavior at run time: Source file

See Scope - SQL Compiler Directive Options for more information.

Parent topic: SQL Compiler Directive Options
Related concepts
Transaction Support for SQL CLR Stored Procedures
Scope - OpenESQL SQL Compiler Directive Options
Related reference
SQLCLRTRANS