Automatic alert to other users

Vipin d

Hi friends, I am using MS.net 2.0 and MSSQL2000. I have some doubt regarding automatic alert messages. I have 3 users like U1,U2,U3. When U1 submit (insert) a data into the database, an alert message will show to U2 and U3. Be thankful for any suggestion...

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Abhijit Jana

you can use Trigger for that

Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"

Guffa

The HTTP protocol doesn't support sending anything from the server to the client. All communication is initiated by the client, so the browser has to poll the server at a regular interval if you want the client to be aware of anything that happens on the server.

Experience is the sum of all the mistakes you have done.

Guffa

Well, you could use a trigger, but that's rather pointless as the web application already knows when it's inserting something. The trigger could only update something in the database that the other clients could poll for, and the web application can do that by itself without a trigger.

Experience is the sum of all the mistakes you have done.