Sep 25 2022 09:23 AM
Hello Friends,
Can i connect 2 databases located in a same instance with 2 different user names.
If so then how the query to get the link and insert/update in destination table.
Sep 25 2022 10:41 PM
Can i connect 2 databases located in a same instance with 2 different user names.
@Manas1978 , not very clear what you mean here?
If you want to change user context, then disconnect and re-connect with the other credentials.
Or do you mean within one cross-database query? Impossible.
Why do you want so at all?
Olaf