The execute in sequence, one after the other.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988




"Maskevich, Tony"
<Tony.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
colab.com> cc:
bcc:
24/04/2003 11:28 Subject: Trigger Question
PM






Does anybody know if the SQL triggers are single threaded or multi? In
other
words, will SQL Server start one procedure and wait for it to complete
before starting the next one. Or will multiple procedures whenever the
MessageRecipients table is updated?

Tony






**********************************************************************
"The information contained in this email and any attached files is strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Aon Risk Services Australia, Aon Consulting, Aon Re Australia Ltd and other associated Aon Companies on +61 2 92537000 and promptly delete this email and any attachments.

The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Aon's permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files.

Aon advises that this email and any attached files should be scanned to detect viruses. Aon accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files."
**********************************************************************

MS Sql Server LazyDBA home page