Change Notification with Sql Server 2008 - Stack Overflow

Yes, this blog post explains that Notification Services is now deprecated, and also what the replacements or alternatives are, going forward. For your purposes - getting notified of changes that occurred in the dataase - it sounds like you want SQL Server

stackoverflow.com