Under what circumstance would you ever need that? It would help to have an actual business example to understand why you'd want that.

In general - if you're trying to create an async processing model in SQL Server, you'd want to look at Service Broker. Within a single process, you usually don't want to be monkeying with threading (since SQL Server handles that for you)

----------------------------------------------------------------------------------Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?