Right, time to publically sell my soul to M$...

I have a table which has an insert trigger. This trigger isn't concerned with data validation or anything. Instead it is used to run some system calls via xp_cmdshell(). These commands take a while, and the point of them being there is they will update the rows that were inserted to call them. The data is being inserted by an addnew() call via and adodb connection in ASP.

Concurrently with this triggers execution i want to be reading the values that the trigger is updating on this particular rows.

So the problem seems to be that all the while this trigger is running i'm unable to read that particular row, which is causing my end ASP script to hang until the trigger completes.

What can i do to get around this? I've tried adding (NOLOCK) in whatever places i can find, but i'm unable to find much online about it.

Cheers