Hi guys and gals, my question for you is:

I have a VB.Net application that connects to a SQL Server database on my web host at GoDaddy. I'm wanting to use it for a chat program so that users can add messages to the database and then everyone else gets the new messages when it re-queries the database.

The only problem is that the only way to get the new messages is to re-query the database every # seconds.

Is there any way to have my program not re-query the database until an entry is added by another user?
Would the SQL.SQLNotificationRequest be used for this?

knxrb