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 |
|
beyonder422
Posting Yak Master
124 Posts |
 Posted - 2007-11-28 : 17:07:47
|
| Does anyone have any ideas or sample code for firing a stored procedure using an MSMQ message?I have to assume XML is in there somewhere.(ie. create XML formatted message with proc call as element?)Just getting started on project, any help appreciated.www.beyonder422.com |
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2007-11-29 : 10:04:53
|
| No takers?www.beyonder422.com |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-29 : 10:13:07
|
| you'll have to provide a bit more info about your setup..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2007-11-29 : 10:50:02
|
| I want to run a service on one box that sends an MSMQ message to a sql server on another box.I have set-up MSMQ on both boxes and have the service that can directly call the database, but I wanted to try to do it via MSMQ.We have a third party product that does something similar. I see MSMQ journal entries in XML format with stored procedures and parameters in the message, so I wanted to duplicate that process.www.beyonder422.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-29 : 10:56:39
|
| have your service call a stored procedure on the sql server with the xml as imput.in the sproc you can do whatever you want with xml._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
call stored procedure from MSMQ message