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 |
|
ssrikrish
Yak Posting Veteran
69 Posts |
 Posted - 2007-12-25 : 11:17:52
|
| Team:How to invoke a stored procedure "out of process", meaning i want to add it to a queue.Reason: we have a proc that is fired real-time each time an order comes into the system and it take a few seconds and when there is plenty of order activity in the system, the process times out. I would like to essentially add this to a queue and move on and some other process will process from the queue. Is CLR call the way to do? I know that the easiest way can be to add to a table and process from the table every 5 mins or something like that. Thoughts?ThxSri |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-12-25 : 12:33:50
|
| Duplicate post - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94676 |
 |
|
|
|
|
|
out of process SP invoke