Is there any sample code to demo the SSB send messages with same sql instance?
my case is very simple:
I want write a stored procedure to send a xml to another database. The stored procedure is called by tables triggers when some data is changed under the specific conditions.
this should be exactly what you need:
http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker
No comments:
Post a Comment