Real time Monitoring of Database

[xRage]

Hi, I am converting an application to work with SQL.
I need the application to monitor a specific table, so it can instantly pick up on changes. The sql server database is on the same machine.

The table it needs to monitor is called MaintenanceRecords and it is inserted into via web service.

I need to display a message in my VB project when an insert occurs in MaintenanceRecords table.

Any insight into this would be great.
I am using Visual Studio 2008, Visual Basic; Windows Forms.

Thanks!

 

[cjard]

Notification Services in SQL Server 2005

I am using Visual Studio 2008, Visual Basic; Windows Forms

Please update your profile. It shows 2005

 

[xRage]

After reading the summary, this seems to be what im looking for.
Thanks, XR

and with regard to updating my profile.. i use many versions depending on my project. this is the first ive used 2009, the majority of my work is in 2005.