Thank you. You posted a question and still worked on solving it. Thanks for posting back the solution you found.

Heh, that is the way I...

Lowell's solution should work nicely for you.

One question - will the order of the records always be the same (agegroups will not get out of order)?

Deadlocks was the primary goal.

The Backup plan was to discuss an inventory solution. More lessons on getting to know your data better. I feel more comfortable...

Lowell (1/11/2010)

---

ok i think i'm following along; i created a brand new database in SQL 2005, and ran the following script to generate the revoke statements; i think the difference...

Wayne,

set statistics xml on

Or Click show actual...

Jeff Moden (1/11/2010)

---

:blush:

Still, that's an interesting warp on the "quirky update". Nicely done, Wayne.

It would be interesting to run a...

WayneS (1/11/2010)

---

Good feedback Jeff.

Probably not random enough, but I changed the 5 initial rows (abc xxxxx, etc.) to be:

1st row: abc 1,

2nd row: zyx 100,

3rd row: def 10000,

4th row: ghi...

And now, while I was typing up my last post, I see that Wayne has gone and updated the script he provided.

lmu92 (1/11/2010)

---

Ok, I now have had some time to go back and redo the tests.

I found one flaw in my tests - they were not equivalent. In the...

Worth a shot on the service account. Set both to use the same account.

I will get back...

Is the Browser Service running in both instances?

Also, is the server defined using the \InstanceName or using the ,portNum method? Have you tried both methods?

Are you using named instances by chance?

lmu92 (1/11/2010)

---

CirquedeSQLeil (1/11/2010)

---

I have tested both scripts and compared results.

I would go with the script provided by Wayne. When the result sets are small, then both are similar. ...