I have a project where I need to audit changes to my SQL Agent jobs. I will need to be able to query on when, what and who made the changes. Is there a way to write the SQL Agent logs to a SQL table so that I can query on it? Or is there a better way to audit the SQL Agent Jobs so that I can query on it?
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!