If you're using 2005, it sounds like sqldependency may be a better
solution for you. Have you check into that?
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Wed, 18 Jan 2006 04:59:02 -0800, "Franz"
<[email protected]> wrote:
>I've got some questions about using the Notification Services with Sql
>The problem is that I've to notify a remote Application about changes
>(insert, update, delete) in a certain set of database-tables via network.
>As far as I know, I've to use/implement IDeliveryProtocol:
>In the Initialize-Method I create the connection to the remote host.
>In DeliverNotification I'll send the name of the change table and the
>In the Close-Method I close the Connection.
>But how do I have to define the events and the tables to get notifications
>I've checked the corresponding samples, but they do not help me any further.
>Thanx in advance