Two purposes. First I need a copy button on the website that duplicates the selected projects that a customer has created using our service.

Secondly I want to be...

If you duplicate rows in B then the ID's change so C has to reflect this. Maybe you know something I don't but I've had to resort to creating...

Thanks for your help with this. I went with the last solution as it didn't require stored procedures which I was having issues with and seemed to be the...

Thanks for the replies.

I used the first script to create a function and have been able to run it using select dbo.GenerateCode(rand(),8)

however the last three characters are always...

If that becomes an issue then I can filter later.

Grant, you have been most helpful and I appreciate the time you have spent replying to my issues.

If you pm me with your address I'll post you a bottle of...

OK I've learned something new and irritating about SQL server/ADO which seems to be the cause of my problems (and likely other people's too.) It would seem that Profiler does...

Thanks. Just realized you have a book, I will buy and read once my panic is over!

I was looking at covering indexes yesterday, I have to admit I hadn't...

Thanks for all of your help so far. I think the cause has now been found. The error occurred twice more during the night and each time the...

OK It just went down so I ran the sp_who2 command several times.

There are 4 queries (all INSERTS and DELETES) listed with BlkBy numbers 100. When I check the...

Hopefully because I'm only looking at a small number of transactions in the profiler (those over 15secs) there won't be a big performance drain.

Can you recommend any third party software...

Thank you for your help with this. It is very much appreciated!

I figured the profiler wasn't giving the whole picture but at the moment it's the only way I...

Also I've been checking through the profiler results and I cannot see any mention of the big delete query but that could be because I've configured profiler incorrectly.

I am using...

The big delete could be thousands or rows. Not sure how I would split it up. Is there some kind of DELETE TOP 1000 command?