Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trigger - Service broker Expand / Collapse
Author
Message
Posted Friday, July 23, 2010 4:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 09, 2010 4:41 AM
Points: 1, Visits: 8

Hello!

I have to solve the following task:

After Inserting/Updating/Deleting records I have to call a web service to exchange data with an external location. 1. The synchrone way: I implement as stored procedure which call the web service and call the stored procedure from the trigger. 2. Something does not work. I have to place all inserted/updated/deleted records to a temp-Table and call via a windows service (interval 5 minutes) asynchronely the web service to transfer the data.

Questions: 1. Do trigger influence the perfomance? 2. What is the best solution to the second task? Can I use service broker to do the job?

Best regards, B.S.
Post #958331
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse