Search code examples
sql-serversystem-traytrayicon

Notifier for System Tray - Fire when new record gets created in SQL Server

Work on a support helpdesk. New tickets come in and records are created in a SQL Table and they are dumped to a specific category where any analyst can pick them up.
Front end does not notify analysts when there are new tickets, so have to contonously refresh the front-end (browser) to see if new tickets are coming into the 'To Be Assigned' folder.

Id like to create a notifier (similar to something like GMail Notifier) that sits in the system tray.

Anyone got some good starting points, or possible snippets that would give me some enthusiasm to actually get onto creating some sort of notifier?

Thanks

Solution

  • Polling is one way to do this, but if you are using SQL Server 2005 or later, a more elegant solution is to use SQL Server Query Notifications. This allows you to specify a query (for example "SELECT ID FROM Tickets") and be notified when the results change. There is a great tutorial on how to do this on CodeProject:

    http://www.codeproject.com/KB/database/QueryNotifications.aspx