INSERT INTO remote table on different server with OUTPUT clause gives error
(re-wrote, misunderstood)

If you want the remote ID, then the best way is to use a stored procedure on the remote server and return a result set.

Or don't redirect into a temp table/table variable. This isn't in scope on the remote server

See these on SO:


https://stackoverflow.com/questions/4537560/get-identity-from-another-serverlinked-server/4537600#4537600
https://stackoverflow.com/questions/2621887/sql-server-identity-issue/2621940#2621940