>Thanks for the help!
>
>I am trying to retrieve data from the remote server based on a set of local IDs. To do this by building a temporary cursor on the remote server that just contains those IDs, then executing a stored proc to return a cursor from the remote table of records that match those IDs, do you need rights to allocate space on the remote server (ie: more than just read only rights)? Also, do you have an example of how to build this temporary cursor on the remote server or can you point me in the right direction for locating the needed commands?

What is the remote server? SQL Server, Oracle, ...? Yes you do need more than just select or read privs.