Its a nice artical but will it work in multiuser case? If same users deletes the product at the same time? I don't think so as in that case ContextInfo...

We have different imports for loading data in database. We are using 2 options:

1. Fetching data from front-end from excel. Making XML. Passing XML to stored procedure. Filling temp table...

NOLOCk is used for reading the data in select statement. My scenerio is at one point one user is inserting the records through import from excel to database & at...