• The security issue is a good question. I wouldn't mind learning more about this myself.

    As for how to link servers, I've had good luck with the sp_addlinkedserver SP. Did you come across this in BOL?

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/