I thought about using a remote view but I wanted to explore some other options. My main concern is speed of the update and network traffic. The first choice would be to schedule a DTS package job to run in the middle of the night. I would like to have the user be able to run this job either directly or by a stored procedure (if possible?) Would it be better to use a remote view with a possible record set of several thousands?

Thanks
Kelly