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, shou开发者_运维技巧ld I use a stored procedure call from CLR in a new thread or just use sql triggers?
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.
精彩评论