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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-21 : 09:38:30
|
| Tom writes "Is there a way to insert a row into a table (acting like a queue) as part of a transaction and then have a stored procedure fire that is not part of the transaction to process this queu table. I looking to record a web user's vote and respond quickly but do a lot of processing in the background emulating message queue without the complexity.The best I could come up with is have a task on a timer that keeps firing and looking for queue rows to process." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-21 : 09:46:18
|
| That's the approach I and others have used. Fire a job every minute checking the queue. |
 |
|
|
|
|
|
fire a asynchronous stored proc to process in background