Single thread in your words.
Triggers will execute one by one.

-----Original Message-----
From: Maskevich, Tony [mailto:Tony.[Email Address Removed] Thursday, 24 April 2003 6:59 PM
To: LazyDBA.com Discussion
Subject: Trigger Question


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
MS Sql Server LazyDBA home page