If you're keeping offline copy of a table, you can add datetime field to the SQL table and update it in the trigger every time records is changed. This way you can pull over only records that were changed since your last download and update your local copy. For deleted records you'll have to store there primary keys and datetime in some other table.
>
>A table contained over 2000 records, which are updated concurrently about a week time. During this period of time, the data in this table is mostly unchanged. If I use remote view, the >2000 records will be downloaded everytime I use the table... so I am looking another way to just get the updated file...
>
--sb--