CREATE TRIGGER tr_person_setPersonID ON person AFTER INSERT AS DECLARE @newid int SET @newid = (select max(P.person_id) + 1 FROM person P JOIN inserted i ON i.study_id = P.study_id WHERE p.study_id = ...

Running the code between BEGIN and END works fine, but when I create the trigger, I get the following error:<BR><BR><I>"Maximum stored procedure, function, trigger, or view nesting level exceeded ...