1
Reply

how to connect multiple databases in single connection object?one example

sainath reddy

sainath reddy
15y
11.4k
0
Reply
    Maddy
    For Connecting to multiple database using single connection, the user name used in the connection string should have access to the database.

    eg: Say we have two db Test1 and Test2 and the initial database in the connection string is Test1. For Selecting data from Test2 db, one should use the following query:-

    Select * from Test2.dbo.Emp.

    Again, this query will only get execute only if user has access to Test2 db.
    Maddy
    14y
    0
Message