I need to write some C# code that will monitor a SQL table, and when a new record is inserted, it will create another record in some other table with that newly inserted data. I need to be guarenteed that this will work every time. This will be a 24/7 running windows service as the host.

I can just check by doing a 'select where not in...', but I'm wondering if there's a better way. Is SQL Service broker still the only game in town for this, or has something came a long through the years that is more reliable?