Viewing 3 posts - 1 through 3 (of 3 total)
Thanks for reply.
I seached SQL Server Log but unable to find anything about it, where do I find, atleast username by which this problem occured.
September 25, 2008 at 3:49 am
#876853
Triigers have specific order for execution, we can change it by :
sp_settriggerorder 'TriigerName', 'LAST', 'INSERT'
see help for OBJECTPROPERTY in MSDN for more details.
September 10, 2008 at 1:13 am
#869426
select objectproperty(object_id('NameOfTrigger'),'ExecIsLastInsertTrigger')
gives result as '0' if not or '1' if yes
September 10, 2008 at 12:55 am
#869417