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 |
|
amex45
Starting Member
16 Posts |
 Posted - 2002-07-22 : 09:42:41
|
| Is any body know is there a way to send each and every transaction or modification on a particular table to message queue from SQL Server? Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-22 : 10:00:31
|
| If you're talking about data modifications, you could write a trigger that use sp_OA procedures to call a COM object to populate the message queue. If you have heavy data modifications you could end up with process blocking and/or high CPU usage however.If you're talking about structure modifications, no. The best you can do is run SQL Profiler traces and put the results into a table, and then have a component query that table and generate the necessary MSMQ calls.Why do you want to put these calls into the message queue? |
 |
|
|
|
|
|
Message Queue