MS SQL Triggers: how many tranasactions could i have ?

[afrika]

hello,
I would like to know how many transactions you can have in a trigger and how many if statements could be nested in a trigger ?

e.g.

if @@error = 0
-- transaction 1
begin
--statements go here
end
else goto option1

-- transaction 2
if @@error <> '0'
begin
--statements go here
end
else goto option2
option1:
--statments

option2:
insert into error_table (msg)
values (@@error)
Would a trigger like this be ok ?



Afrika

[swampBoogie]

I don't see what you mean by many transactions. The code within a trigger is executed within the same transaction as the statement that caused the trigger to be executed. Are you thinking of nested or parallel transactions or what?

In general, it seems to me you are putting to much application logic into triggers.