Lesson Learnt while Configuring Security on a Job Running through Linked Server

This case taught me a very useful lesson about how impersonation works when executing a SQL Server Job using a linked server. If this scenario is new for you too, I hope you enjoy learning as much as I did. In this case my customer was trying to run a stored procedure using a linked…

1