What's the affective way to track SQL table change

What's the affective way to track SQL table change

I have a Bugs tracking system wrote on asp.net, and i need to track about
bug updates and show history of a bug, what the current status, updates,
etc...
So, i need to know witch field is change, and do something with the data.
I created another table, that have the tracking tables field's and the new
value, so on change i insert a updater key (on another table, indicate who
change it and when), changed field name and the new value.
it's work awsome with c#, but i need a more sql's solution.
e.g the value field in my changes table, can be fk for X TABLE, Y TABLE or
a simple number or string that i casting to string.
What you are think about my solution? Can you offer a better one?
Thanks.