I would be interested in your experience regarding performance. The experience we made was that performance decreases significantly on a VM based system instead of using a HW based one....

thank you very much. I didn't even think of using default values. That's much better.

Greatly appreciate your help.

cheers

Sergio

I had listed the code above. Here we go again:

create TRIGGER [dbo].[tr_bi_business_test]

ON [dbo].[business_test]

FOR INSERT

AS

BEGIN

UPDATE dbo.business_test SET modify_user=USER_NAME(USER_ID()),

create_timestamp=GETDATE()

WHERE business_test_id IN (SELECT business_test_id FROM inserted)

END

CREATE TRIGGER [dbo].[tr_bu_business_test]...

ok. Could you please elaborate on that matter?

thank you for your help. Unfortunately the triggers are really very simply and only set time and userid to the record. However, I will revisit it again.

Ah. Ok I understand your question now.

Yes, I know that during this time the triggers aren't firing. However, for reasons which are not important, I can quarantee that I...

Thanks for the quick reply. Now it makes sense to me.

One thing I have omitted was that there is also a BEGIN TRY where I would rollback the transaction in...