Thank you, James.  Good suggestion!

We finally solved our trigger problem.  If a row already existed in table STUDENT_T with the SSN value found in INSERTED, we would receive an insert error.  Violation of PRIMARY...

I don't get a value from the select statement about the TriggerDisabled.  Both triggers fail.  When I ran a debug in QA the code never lands on the trigger;  it...

CREATE TRIGGER insertMedPerson_T

  ON SWCSPersonnel.dbo.PERSON_T

  FOR INSERT

AS

  INSERT INTO SWCSMedical.dbo.MED_PERSON_T (SSN)

    SELECT SSN FROM INSERTED

CREATE TRIGGER insertStudent_T

  ON SWCSPersonnel.dbo.PERSON_T

  FOR INSERT

AS

  INSERT INTO SWCSStuMgt.dbo.STUDENT_T (SSN)

    SELECT SSN FROM...