SQLServer Service Broker / Notification

[Former Member]

Hi all

we would like to use the SQLServer Service Broker to send notifications from a B1-database to another database (not B1). In order to do this we have to define message-types, contracts, queues and services inside the B1-database.

The Service Broker will be triggered by the SBO_SP_TransactionNotification procedure.

Is there someone that can definitely tell us, whether this is allowed (according to the SAP B1 license-agreement) or not and whether this definitions will be wiped out during a B1-Update?.

Kind regards

Max

[Former Member]

Im not sure if is this allowed (I think that no), but for me seems it better to trigger this from posttransaction notice sp - when it will be in transaction notification, users will wait for triggering, in posttransaction it will triggered after completed the transaction and user will not wait.