Don't know if it might help, but the INSERTED pseudo table (inside the trigger) already contains the "to-be-commited" identity values (if the table has an identity column). For example:

SELECT max(MyIdentityColumnName)...

I know 🙂

If it doesn't help the author, it might help someone who was searching for answers :-). I found this post via...

A clustered index must be re-ordered when it is updated. That means the whole index is basically reorganized, and that is why it's expensive. A primary key (PK) is usually...

verena_techie-1005324 (1/6/2010)

---

My quote is out of context... Walk a mile in my shoes, then you might be enlightened too. There is no sense in saying women are exactly the same...

verena_techie-1005324 (1/6/2010)

---

My brain does work differently from most men, I can look at a problem logically, but I also look at it creatively. This is what often makes a woman...

What steps exactly do you suggest be taken to reverse the trend, Mr Phil?

Very good method.

I'm just not sure if I would want to be any one of the users connected to the DB while the script is run, since I will get...

Thank you.

Now it is clear  I agree now that #2 is the correct answer. It helps to re-read the question a couple o' times...

We do not know what the param was. We assume it was 0?

From the msdn site "...However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value..."

It doesn't list possible reasons why it might be...

Yes indeed. Very valuable feature. Performance can be greatly enhanced by this, where triggers may be replaced. Those wondering about the missing spaces...

In the first example block, SELECTSCOPE_IDENTITY()...