SQL Server events and .Net Framework

Hi, I'm developing an application (C#) that must monitor a database table and do things with the new records inserted on it.
The insertions are made by another application.
Currently I'm doing the monitoring thing with a loop in which I check for new records, work on them if any, and mark them as processed(setting a value in a field).
I want to know if there is any way to do this catching an event generated by my MSSQL server when a new record is inserted. Can MSSQL 2000 send a message to my application telling it that a new record was inserted? I readed several forums and I found what I think is a solution but for Visual Basic 6, nothing for .Net.
Any insight is helpful. Thank you very much.