Options

How to Popup the messages to the users connecting to Server

ajaybabuChajaybabuCh Member Posts: 208
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
Ajay

Comments

  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Have a look at this download: Chat messages
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    ajayjainajayjain Member Posts: 119
    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.
    Ajay Jain
    UK
  • Options
    ajaybabuChajaybabuCh Member Posts: 208
    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
    Ajay
Sign In or Register to comment.