all groups > sql server programming > october 2004 >
You're in the

sql server programming

group:

Sending message from sql to program


Sending message from sql to program majid947
10/15/2004 11:29:04 PM
sql server programming:
I'd like to my program notified from som inserting or updating in database.
At present i use a timer in my program to check database.
Re: Sending message from sql to program Mike Epprecht (SQL MVP)
10/16/2004 3:29:08 AM
Hi

Look at SQL Notification Services. It may be something that could help you.

http://www.microsoft.com/sql/ns/default.asp

Regards
Mike

[quoted text, click to view]
Re: Sending message from sql to program John Bell
10/16/2004 12:14:30 PM
Hi

If you don;t need real time notification the standard auditing type of
process (an example is in Books Online "CREATE TRIGGER" topic) or a log
reader such a Lumigents or PI may be sufficient.

John

[quoted text, click to view]

Re: Sending message from sql to program Jonathan Chong
10/16/2004 4:49:27 PM
You can use extended stored proc to send message through socket programming
to your application.
This extended stored proc will be called in trigger for insert and update.

[quoted text, click to view]

Re: Sending message from sql to program Jonathan Chong
10/16/2004 10:50:41 PM
Yeah, I heard about that and anyone would like to share its performance
here?
So far I have been using extended stored proc to send data through TCP (for
financial services) and very happy with its performance and reliability.

[quoted text, click to view]

AddThis Social Bookmark Button