Your error message infers that your isolation level is not "committed read" (hence my warning about this in my original response). The MS article infers that you are trying to set the isolation-level in the "GetNext" SP, after the transaction has been started. If you are using ADO then the connection's "IsolationLevel" property should be set to "adXactReadCommitted" before the transaction starts. You need to be really careful about the isolation level and the scope of your transaction otherwise you will find that your separate processes will have to wait for each over to complete - if you do it really wrong then you could find that parallel processing actually takes longer than using just a single process. The technique that I specified should work even if you don't use the "READPAST" hist specified (so long as you don't start a transaction in your client-side code until AFTER you have called my SP. Hope that helps. Andy

Search engine optimization isn't a subject I'm particularly familiar with. However a quick Google[^] search threw up some interesting articles. Url rewriting appears to be a recommended technique for optimizing dyamically generated web pages with search engines. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

A client of mine does sales lead generation and under our NDA I cannot really go into detail how he takes care of the problem. In short, we have not ever had the abuse happen. BungleBonce wrote: My only hint that it does is a note on the contact form of a competitor site indicating that any misuse of the enquiry form will be "reported and investigated and appropriate action taken" That is perhaps the best route... "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon