|
| [WM23] Stored Procedures on a server |
| Iniciado por ARV, dez., 13 2019 9:07 PM - Sem resposta |
| |
| | | |
|
| |
Membro registado
514 mensagems |
|
| Publicado em dezembro, 13 2019 - 9:07 PM |
Hi everyone,
I'm creating this thread because I want to know if it is possible to get access to another data base through a stored procedure on a server.
Here's the situation
I have two DB let's call it
DB1
DB2
on DB1 I have important tables of information to show to the user
on DB2 I have tables for managment connections to a lot of DBs
I want to create stored procedures for DB2 but those stored procedures need information of tables that only DB1 have.
I was hoping if there's any way possible to access the tables of DB1 through stored procedures of DB2.
Hope anyone know about a function or if I need to set something to make it work.
Thanks!
--
Best Regards
ARV |
| |
| |
| | | |
|
| | | | |
| | |
|