• Is it possible that to find a particular login belongs to which group?

    I can see a login created with windows authentication in server A. I am not sure is it included in any group or not in serverA.

    Server A has linked server with B.

    But I didn't see the same login exists on server B.

    so how to find that the login belongs to a group or not in B and as A?

    Here serverA means Sql server, is installed on machine A and Sql server B is installed on machine B.

    It is able to select the data from the linked server but not able to update. They are saying it has update statement will also works?