At a minimum you need to 1) script out the a_District table and 2) do as Ninja asked and add a "Print @cmd" to your p_trigger procedure right before the "Exec (@cmd)". Then post both of these things here.

------------------------ERRORS DISPLAY ON THIS LINE, OF COURSE THERE IS SOMETHING------- ------------------------FISHY HAPPENING BEFORE IT HITS THIS POINT-----------------------------------DOES NOT GET PAST THIS POINT----------------