如何确保表触发SP已完成使用数据？

I have within my Sql Server 2008 database a trigger which will run on insert and update to populate a calendar table with dates calculated from the date info in the first table. (i.e. start date, end date, repeating sequence information).I have within my Sql Server 2008 database a tri