thank you for the reply

can you give a sample of the procedure , they're on different servers

and what if the fields are different types in each database