Tag Archives: trigger

SQL Trigger to find who updated a table and when it was done

I had a situation to find who is updating a table and when the table is getting updated but it was very difficult to enable trace for a long time. I end up creating a trigger to capture the user … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , | Leave a comment

Knowledge Share 2014-05

* Function to convert a list into a table (Collected this piece of code from my Colleague, Satya Addala) * Computed columns can not be altered but needs to be dropped and re-created * Caution while creating DDL triggers, specially … Continue reading

Posted in knowledge, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

Task scheduler – Event Log Trigger – Include Event Data in mail

In first part of this article I cover how to edit the existing Task to send Event Details but I will skip basics of Task creation. Step-1: Create a Job which will trigger on an Event during specific condition Step-2: Right Click … Continue reading

Posted in Productivity, Script, Windows Server | Tagged , , , , , , , , , , | 18 Comments