Suggestions on how to role my own with the API? I know I could access the
Stored procedures directly, but would like to refrain from that, and
I'm not clear on how to get at the database connection that the API uses
"Joe Webb" <[email protected]> wrote in message
> Wayne -
> As Kate mentioned in another post, a custom delivery protocol may
> address your delivery issues.
> As for transactional support for the NS API, you're right it's not
> built in. But you can always roll your own if need be.
> Joe Webb
> SQL Server MVP
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> On Thu, 18 Aug 2005 07:42:24 -0400, "Wayne"
> <[email protected]> wrote:
>>We have a need to send events out to multiple devices for a single
>>subscription, the user may be able to decide what devices with what
>>subscriptions. So far we have the following two ideas for accomplishing
>>create a multiple subscriptions, one for each device the user wants the
>>events to go to
>>create a multiple unique device entries for each subscription
>>So far as I've been able to tell there is no transaction support when
>>the notification services API, so having to update multiple records for a
>>single subscription can lead to further maintenance issues if the updating
>>were to fail part way through.
>>Is there a simpler way to have events for a single subscription to go out