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
