- Giving Permissions through Stored Procedures
- Understanding ownership chaining, particularly cross database ownership chaining can be tricky, particularly when techniques such as Dynamic SQL can break the ownership chain. This is a great article by Erland Sommarskog SQL Server MVP, that looks at ownership chaining and how to get around the issues that arise when using Dynamic SQL, through the use of signed stored procedures.
- SQL Server Agent jobs and user contexts