Another "might be this" post. Based on the fact it didn't complete even over many hours, you might want to eliminate the possibility of parallelism with an undetected block....

Perhaps what you're looking for is merge replication with parameterized row filters. Basically each POS location is a subscriber to only the rows in the table that it created....

Similar situation occured here today. This time it was a table variable used in an instead-of insert trigger. SPID blocking itself and the contended resource was the table...

Just a note of encouragement:

Recently moved model according to http://support.microsoft.com/kb/224071.

Problem: Kept getting "Cannot detach an opened database when the server is in minimally configured mode" when...

Thanks for the replies and suggestions, Michael and John. Gives us something to look into. Cheers.