Hi Professionals,

I want to know how database let application know is any DML operation
occurs.

We have an application in C++ and in the morning it cached all the USERID
and Password into the memory, now what I want is if user change the
password, we have to have any mechanism through which database let
application know that you need to cached that specific USERID and PASSWORD
again so it hit the database again for specific user who changed the
password. I was thinking may be there is Messaging Broker service can be
helpful in 2005, I am not sure. please advice.

Thanks in advance.