I ended up doing this with a cursor. NOT the best way I'm sure but there isn't much I could do as I needed to produce a result quickly.

From what I can see it is not to work with SQL 2000 - but I've only started playing with the code from my search 🙂

Thanks for the reminder to add in sample data. I've edited the post to include what I'm looking for.

I figured it out. CHARINDEX is subject to the 8k limit (even though is works on the TEXT data type). Once my PATINDEX was finding pattern matches after...

Yup - I'm all over that - this time I'm piloting the new stored procedure with users - adn I will add users until we eitehr have a failure or...

Thanks - I would really appreciate any addition info anyone can offer.

I know that the next step is going to be to have to explain a) why this is happening...

While i agree that the .AddNew seems to be part of th issue, I get the same problem if I simply run an INSERT INTO command using Query Analyser, I...

UPDATE: This morning when we started back to working within the tool we are getting timeouts again without the Primary Key.  I'm wondering if the recoding of the asp will have...

Thanks All for your feedback.

Antares686 - Are you suggesting that removing the index but leaving the IDENTITY leaves me open to the same issue?   Or are you saying that the Identity...

Thanks all for the ideas.  I'm actually pretty anal about cleaning up connections properly, so at any time (even with a few production database apps running) I have very few...