Is user defined messages possible in MS SQL?

[ertug]

Hi,

Is it possible to define a message in a trigger and broadcast to the system? This will be useful to understand when a record is updated/inserted to a table without checking the table with a timer by an application.

Thanks. [sig][/sig]

 

[sgibbs]

You can use sp_addmessage to create the message and then refer to the message in the trigger just as if it had been a system error number.

Good Luck! [sig][/sig]

 

[ertug]

Thank you, I will try that. [sig][/sig]

 

[foxdev]

Ertug, you mentioned that you wanted a &quot;broadcast to the system&quot;; not knowing for sure what you mean, you might also consider using xp_sendmail to send an e-mail message when a row is inserted, if that suits your needs. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[ertug]

Thanks friends,

I have found the answer. The solution is writing an extended stored procedure using VC++ or Delphi 5. A sample code can be found at:

http://www.tair.freeservers.com/cpp/xp_Works.html

Thanks again. [sig][/sig]