I have a requirement to copy whatever data is getting inserted or updated to a log table to show who updated and when. I was thinking of using triggers for the same. The reason being the insert needed not be only stored procedure but can also be packages. Can I use extended events for the same ?. ...
I'm trying to find out what is updating the value of a column and i have very little knowledge of the application. At a quick glance I've noticed about 90% of the applications business logic is handled on the database. Needless to say the depth of SP's, functions, and triggers is crazy. I'd like to create a trigger on the table in quest...
From another thread that gave me the information on how to add monitoring to an SQL Server... http://stackoverflow.com/questions/3586736/see-sql-from-entityframework-with-collection-like-queries This works well, but I want to take it a step further. I'd like to be able to add comments into the log when Transactions are happening. I w...