I was just wondering if you could help me out with this query -
I have an instance created within which you have 3 databases say A , B and C.
I have a Stored Procedure created in A say A.proc1.I have a requirement where I have to update some tables in B and C database.
Is it possible to select or update any table from B database in this procedure cause I have a requirement where I have to update some tables in B and C database whereas the procedure is been created in A database ?
|