Trigger into SPROC

  • There is a caveat to using such generic temp table names as #Ins and #Del. If the trigger is called from some other procedure or invoked by another trigger that also has temp tables name #Ins and #Del you will have problems. Temp table names are inherited by child procedures and triggers in the same scope.

    Todd Fifield

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply