cons of linked server providers not running in "allow in process"
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.