I gotcha. So, build a job and run it every few minutes? That sounds good.
I need to update one database with the data from another database on a regular basis. If I do this with a job, will I be able to only copy over the data that was added since my last job ran? This way, I don't have to copy the entire contents of the table each time.
I'm sorry about all the newbie questions. I appreciate your help!