Hi, 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? Cheers Elisabeth...
Hi,
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?
Cheers
Elisabeth
Bookmarks