I am new to SQL Server but I have experience of Oracle and SQL Anywhere. Something you can do in both Oracle and SQL Anywhere is to create an after Trigger for insert, update and delete (one trigger for them all) and check inside the trigger if it is an insert, update or delete. If I have understood it correctly this is not possible in SQL Server, instead I have to create three triggers, is this correct?
In the previous databases mentioned above you can also choose to have the trigger for each row, but this is not possible for SQL Server, here it is per transaction instead? How do you handle if several rows have been updated in one transaction and each of the rows should trigger an event?
I might have missunderstood something and f this is the case please be so kind to guide me in the correct direction