I have the following:
INSERT INTO TableB
OUTPUT INSERTED.COL1 INTO AUDITTable(COL1)
This is giving me error:
A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement.
I know that OUTPUT cannot work on remote tables.
So what is the alternative to this?