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.