Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been advised to un-check allow in process.

share|improve this question

closed as off-topic by RolandoMySQLDBA, Max Vernon, Kin, Phil, gbn Apr 30 '14 at 7:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – RolandoMySQLDBA, Max Vernon, Kin, Phil, gbn
If this question can be reworded to fit the rules in the help center, please edit the question.

That option limits the datatypes you can access through the linked server - you'll not be able to access text / ntext / image columns through an externally instantiated linked server, nor row spilling ( MAX ) columns. Not a huge loss, generally.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.