From Books Online
on which it is executed. This function cannot be applied
to remote or linked servers. To obtain an identity value
on a different server, execute a stored procedure on that
remote or linked server and have that stored procedure,
which is executing in the context of the remote or linked
server, gather the identity value and return it to the
calling connection on the local server.
> We can't get a linked server to return the identity row on an insert.
> Can anyone help
> SQL is like
> set nocount on
> insert into xyz ( a, b, c ) values ( 1, 2, 3 )
> this works fine when connected directly to the primary server, but returns
> null when using a linked server.