Linked Server error .... sometimes

  • EDIT: Nevermind, it's resolved

  • A problem / solution post is more usefull to the world than "solved".

     

    Just my 2 cents.

  • Most tables could be copied via linked server, but a few were getting an OLEDB error.

    The problem ended up being that there were triggers on the target tables. I had to disable the triggers, import the data, and re-enable the triggers.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply