I am new to SQL and wanted to know how to write to windows event when a row is inserted into a table.
I basically have a events table which gets rows inserted when a certain event occurs, I need to write the description of the event to windows event logs each time, so it is captured for the support staff. Should I be creating a trigger or store procedure for this? Does anyone have any sample code on how to do this?
Any help will be much appeciated