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.
Forum Discussion
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
