re: stored procedure calling another database

2005-04-01 Thread SGreen
James Black <[EMAIL PROTECTED]> wrote on 04/01/2005 04:11:49 PM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Is it possible to have a stored procedure query another database? > > I have two databases where the second (B) uses information from (A) to > make decisions. > > It would be g

re: stored procedure calling another database

2005-04-01 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is it possible to have a stored procedure query another database? I have two databases where the second (B) uses information from (A) to make decisions. It would be great if the stored procedure on database B could query A, so that it can make decisi