SQL Server -> trigger -> event -> caught by C# program

In SQL Server is it possible to have a trigger that will throw an event which could be caught by C# program running in the back ground?

Is this even possible? If it is, have u any links to help/examples?


a better description...

What I want to happen is that when we import data in to our database
(INSERT) that a trigger is called.

The trigger passes that data into a validation tool that cleans that
data and writes it back to a new clean database.

There needs to be two tables, one containing the raw original data and
one containing the cleaned up data.

The reason this is not done using a program to load the data is to
ensure any data loaded in to the database is cleaned.


Tommy

Why don't you clean the data first (using your cleaner app), then put it in the database? It seems a bit redundant to put in dirty data, then clean it, all inside the DB.