[Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version 0.2.1.0

 

The most recent version can be found here

(The detailed Information of the solultion is mentioned here)

I created a minor update for the logging functionality in order to find the right entry point for injecting the code.

It turned out that finding the occurence of the beginning of the body text does not work if supplement characters are present after the “AS” keyword, stopping the whole process of applying logging to all procedures. I now check the occurence and throw an error if the statement is not formed as expected, but will proceed with remaining procedures.

-Jens