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.