I think I might have found a way to do what I need (but I'll have to hard code the table names) - but one more question, can I execute a stored procedure remotely ?

E.g. EXECUTE my_proc@remotedb