tag:blogger.com,1999:blog-2453693540149032389.post7535570963622805486..comments2023-05-18T14:11:09.911+01:00Comments on sql solace: Sending Service Broker Message on Triggerr5d4http://www.blogger.com/profile/09999231147372917249noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2453693540149032389.post-46540444088222392012011-11-01T21:30:16.697+00:002011-11-01T21:30:16.697+00:00From looking back I believe the cursor was only to...From looking back I believe the cursor was only to send individual messages re; row changes via service broker.<br /><br />Apologies, I haven't touched service broker for 3 1/2 years. You'll have to test, as i believe you only need simple trigger functionality.<br /><br />rr5d4https://www.blogger.com/profile/09999231147372917249noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-88763680014753842392011-11-01T20:21:58.451+00:002011-11-01T20:21:58.451+00:00Sorry one doubt, but it's necessary to use cur...Sorry one doubt, but it's necessary to use cursors? <br /><br />If I make "update Person.Contact set title = 'Mr' where title = 'Mr.'" and I update 10 records, the trigger won't fire 10 times, one time for each record updated?Vincenzo Capellihttps://www.blogger.com/profile/13613570616038028038noreply@blogger.com