I have created this trigger to insert new row into table @AL_ORDR_TRACKER
after new row is inserted in table ORDR
.
CREATE TRIGGER dbo.trgAfterInsertORDR ON dbo.ORDR
AFTER INSERT
AS
BEGIN
INSERT INTO dbo."@AL_ORDR_TRACKER"
(U_DocEntry, U_Updated)
SELECT
DocEntry as U_DocEntry, GETDATE() U_Updated
FROM inserted
END
The trigger gets registered but when inserting new rows into ORDR
I get the error message:
Connection is busy with results fro another commands
What might be going wrong here?
@AL_ORDR_TRACKER
a table? Why are you double quoting it? – McNets Aug 29 at 19:14