InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:55:08 GMT20http://www.sqlservercentral.com/Forums/Topic1395425-391-1.aspxYour description is extremely vague to say the least. Do you an insert trigger on Table1 that inserts data into Table2? And you also have an insert trigger on Table2 that inserts into Table1? That is what I think you are saying. This is one of the reasons to try to avoid triggers if at all possible. You can't get out of that loop. You need to come up with a different way of doing whatever these triggers are trying to do.Wed, 12 Dec 2012 09:17:36 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1395425-391-1.aspxthanks for you reply.but please suggest another way.thanksTue, 11 Dec 2012 23:36:45 GMTelham_azizi_62http://www.sqlservercentral.com/Forums/Topic1395425-391-1.aspxExplore Update() function to stop this behavior. Refer the link below:[url]http://msdn.microsoft.com/en-us/library/ms187326.aspx[/url]Tue, 11 Dec 2012 23:17:20 GMTLokesh Vijhttp://www.sqlservercentral.com/Forums/Topic1395425-391-1.aspxhello all.I have two tables.when insert into one ot them with trigger insert into another and with another trigger insert into first table.that means one loop occurs.waht do i do for solve this loop?Tue, 11 Dec 2012 22:16:24 GMTelham_azizi_62