SQ: Server

Occasional Visitor

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.

1 Reply

 


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?

See Cross-Database Queries

 

Olaf