I have a set of conventions for my database.
for e.g.: select shall be always SELECT and lower case 'select' shall generate an error.
I need to have a table that will save all the errors that are generated whenever these customized conventions are violated. I need to count the frequency of these errors too like how many times did the user executed small cased select.
I need to do this from .NET platforms, that is VB.net.
Kindly guide me.
Thanks