Qns on SQL server and vb .net application communication

Question

Hi all, I'm currently developing an online booking portal and a console application which would be deployed at my client site. This system allow users to make SMS booking. I'm currently having problem with the design of the communication between my database(SQL Server 2000) and my Portal(vb.net web app). I need the SQL server to inform my portal whenever there is a new record inserted after which my portal will tell my console(vb.net windows app) about the new record. May I know is there anyway way/method that would allow me to do so? I would really appreciate any advise. Thanks! With Regards, Chuwei