Forum Discussion
SQ: Server
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.
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