I recently had this same issue, sql 2005 and the linked server is linked to a SAP ASE database server. To resolve the issue I gave the user access to...

Thank you Gail for the prompt response.

I understand what you mean regarding a corrupt DB. I would prefer to know if a Db is corrupt than not know.

GilaMonster (10/30/2013)

---

CheckDB when...

thank you john, think i got it working, just need to mess around with it. using the Employees ID from table 3 to join with Employee ID on table 3.