>So then the next question is ... are there any downsides to using Linked Servers? The SQL Server that will have the trigger on it (SERVER1), is not owned by me (although I will be allowed to set up my triggers on it) ... and it will need to be linked to SERVER2, which would be owned by me. Basically, I'm working on integration of various disparate software systems (which would each have their own database servers). Will this be a problem for my customers? Would most DBAs allow their Servers to be linked to another company's Server or is this not standard practice?
>
>~~Bonnie
I do not know what is standard practice so I can not answer that question, but one thing I would be careful with that scenario is what is your trigger going to do when the linked server (or the connection for that matter) is down for any reason.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
