I have a sproc on ServerA that calls another sproc on ServerB
The servers are connected through linked server.
When the sproc gets called on ServerA it is called by the user login. However, then on ServerB, the 2nd sproc is called by SA.
I would have thought that the user credential would have passed through to ServerB rather than SA?