I have used Java with Oracle in the past. But am a newbie to MS sql server 2000 with Java and have a complicated problem? too at hand?

My project requires that whenever there is a change in the MS sql server database (trigger), my Java program should be informed about it.

I know oracle can do this but how can I do this in MS sql server. I further need to use that information from the Java program and update an applet....somewhat like a real time update whenever there is a change in the MS sql server database.

Suggestions? Code? Ideas?

Thanks in advance.