Subject Re: [ib-support] Re: Connect to DB from Procedure ??
Author Doug Chamberlin
At 8/8/2001 07:06 AM (Wednesday), Damian Dowling wrote:
>The problem is that Databases B, C, D, etc must be updated no matter the
>source of the changes to Database A. I had hoped that it could be done in
>Stored Procedures as it would make rollbacks easier.
>I think that the only solution is to use a UDF.

Using a UDF to connect to another database to make updates is A VERY BAD
IDEA. While on the surface it seems possible, this is UDF abuse, plain and
simple. There are much better ways of doing this which involve event
alerts, logging utilities, and replication systems.