You mean DML triggers. DDL triggers monitor for changes to the schema and objects themselves.

As to the original question, there are two options:

• Triggers on the specific tables
• Server traces

Of these two options, triggers are probably the best fit. Server traces will tell you the query, who executed it, and when they executed it, but it can't return the information on what the original values were. That's going to require a trigger. Triggers have special tables that are used depending on the operation:

INSERT

• inserted - Tells you what is being added.

UPDATE

• deleted - Tells you what the original values were.
• inserted - Tells you what the new values are.

DELETE

• deleted - Tells you what is being deleted.

You're not going to get this information via any other built-in means.