How to get server event notification
Your options are 


to use stored procedures for data access and write log of changes, 
or to use triggers on specified tables to write log of changes


and after it you have periodically poll the log tables to reflect to the tables changes

See related answers:

https://stackoverflow.com/questions/8998545/notifications-from-sqlserver-to-java/8998579#8998579

https://stackoverflow.com/questions/8895595/sql-server-track-table-inserts/8895683#8895683