You need SQL Notification Services. You can use this free addon to SQL 2000 from MS to monitor for changes to a result set and then send an email to the user with a link to the webpage.
With SQL 2005 you can subscribe to these events. So you would need to write a win client that subscribes to the event, and then when the event is fired it can then launch the page
Principal Consultant and Trainer