Can I clarify this settings linked server be made using the login's current security context. If I connect to serverA using windows account JOESmith and create the linked server using the above option to serverB.
What happen when BOBSmith connect to serverA and query serverB. does it use JOESmith credential or BOBSmith?
sorry if this sound's like a stupid question because "current security context" should imply it will use BOBSmith's account to serverB
But I just want to clarify