I need to create a insert trigger so that when a new row
is inserted in table A then the same row is inserted in
table B on a remote server. The problem is table A has no
primary key or any kind of unique field that I could use
as a reference. We can't create an artificial PK because
that would involve too much work in changing SP's that
populate / access table A.

Does anyone know how to grab the last inserted row when
there is no unique / PK field defined on the table?