CODEWITHSUNDEEP
sql-servertriggers
Uğur Gümüşhan
Uğur Gümüşhan

Reputation: 2543

Are sql triggers run in a separate thread?

If I want to return the user a web page and write to a log or word by word processing, should I use a stored procedure call from CLR in a new thread or just use sql triggers?

Upvotes: 0

Views: 1338

Answers (1)

user596075
user596075

Reputation:

You can't make a SQL Server trigger run asyncronously. The best you could do is utilize SQL Server's Service Broker to execute a stored proc call.

Upvotes: 3

Related Questions