Programatic replication

I have SELECT access to a database that is very, very slow to work with to
the point where I am looking to replicate at least one table to my own
server to use the data locally. What is the best way to check for new
records if the table key is not incremental? I prefer not to try a "If
exists" on the entire databse every minute or due to the speed issues.Hi
If you are allowed to change the structure of the table then you may want to
add a rowversion column. If not maybe you should use log shipping to recreat
e
the whole databases?
John
"Dave S." wrote:

> I have SELECT access to a database that is very, very slow to work with to
> the point where I am looking to replicate at least one table to my own
> server to use the data locally. What is the best way to check for new
> records if the table key is not incremental? I prefer not to try a "If
> exists" on the entire databse every minute or due to the speed issues.
>
>