I have a remote view that pulls records from a SQL Server database. It's a relatively simple view, no joins, no filtering, just points to a table.

The remote view works fine, but when I open it via a USE command, the table is open almost immediately, but records continue to be fetched in the background for a while. If I were handling the entire process programmatically using SQLExec, I know how to determine when the process is finished. Using a Remote view, I'm not sure how to determine when the process is finished, and I'd rather not change thins (using it as a Remote View is real easy and I'm almost out of time with this project). Anyone know how to do this?