E
Eugen
Hi all,
After I INSERT or UPDATE a record in a table under a SQL Server 2000 Workflow, from Query Analyzer, the @@TRANCOUNT system variable is 1, so a transaction is started.
Could some one, please, help me, why a transaction is started for an INSERT or UPDATE in a table in a SQL Server 2000 Workflow ?
I am using Office XP Developer for SQL Server 2000 Workflow without any interface, just move the items from one state to other from SQL statements.
Thank you in advance,
Eugen
After I INSERT or UPDATE a record in a table under a SQL Server 2000 Workflow, from Query Analyzer, the @@TRANCOUNT system variable is 1, so a transaction is started.
Could some one, please, help me, why a transaction is started for an INSERT or UPDATE in a table in a SQL Server 2000 Workflow ?
I am using Office XP Developer for SQL Server 2000 Workflow without any interface, just move the items from one state to other from SQL statements.
Thank you in advance,
Eugen