How to Popup the messages to the users connecting to Server

ajaybabuCh

Hi

We have one database in the server with several users.

I have one table that is Messaging

In the “On Insert” trigger of Messaging Table I put the following message
Message(‘I am in On Insert Trigger…’);


How can I popup this message for all users connecting to the server when I am inserting the records.


Actually When I am inserting the records the message prompts in my system only.

Regards
AJAY INDIA

Luc_VanDyck

Have a look at this download: Chat messages

ajayjain

you can try net send command.....

SHELL('NET SEND '+ ComputerName +' ' + txtMessage);

or

SHELL('NET SEND * ' + txtMessage);


make sure you have the messanger service running to all machines.

ajaybabuCh

Thank you Ajay.

Could you please tell me how can I track the IP addresses of the clients connecting to the server dynamically.

AJAY INDIA