I've recently taken on responsibility for a new MSSQL database.
I can see nearly every stored procedure has repetitive boiler plate code which sets up the user context/row permissions and logs execution.
Are there any tools which can be used to simplify and remove the repetition?
Something that would work similar to an entry/exit aspect if I was writing C# code.
I have the full redgate toolbelt and MS visual studio at my disposal if that helps provide a solution.
Kind Regards,
Steve