I created a trigger over my table RDR1 but the error "Connection is busy with results for another command" appears when i try insert a new Sales Order.
alter TRIGGER XXXX ON RDR1 AFTER INSERT, UPDATE
DECLARE @DocEntry int
SELECT @DocEntry = DocEntry from Inserted
Update TableBKP set DocEntry = @docentry