You can't do this from standard T-SQL. The only way is to implement an extended stored procedure that spawns a separate thread. Don't know how to return a result set from this though.