Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | rajkStarting Member
 
 
                                        20 Posts | 
                                            
                                            |  Posted - 2004-05-03 : 07:26:10 
 |  
                                            | Hi,I have a situation where I need to call a web service from the database (by an insert trigger on a table). Please let me know how I could do this.Thanks in advanceRaj |  |  
                                    | ehornMaster Smack Fu Yak Hacker
 
 
                                    1632 Posts | 
                                        
                                          |  Posted - 2004-05-04 : 21:38:03 
 |  
                                          | A trigger most likely will be very inefficient for this type of messaging.  Another option might be to create a windows service which monitors the table, or some message brokering queue (ie MSMQ), which performs the call to the web service. |  
                                          |  |  |  
                                |  |  |  |