At 08:14 PM 13/11/2007, you wrote:

>Hi
>
>Is there way to update a table that resides in another database via a
>stored procedure?

Not directly: one database cannot be a client to another. You need an application to mediate between the two.

Place the SP in the database that is to be updated; write a selectable SP or a query in the source database; have your application pick up the output from the source query and pass it to the target SP via parameters, all inside a single, cross-database transaction.

Replication applications often use stored procedures in this way.

Some DB Admin tools, e.g. IB_SQL (amongst others) provide "data pumping" utilities that allow you to do the same thing.

./heLen