As a suggestion - I think articles like these should not only tell the readers how to use a new feature but also address their usage in real world applications/scenarios!...

From my experience in OOprogramming, the data model doesn't always directly correlate to the object model of the business tier. I know somewhere in there lies the answer but...

K. Brian Kelley (12/11/2008)

---

Kevin Rathgeber (12/11/2008)

---

Mr. Kelley, did I maybe get this wrong in what I was explaining above. Setting the NTAuthenticationProviders to NTLM, is it possible that I...

Mr. Kelley, did I maybe get this wrong in what I was explaining above. Setting the NTAuthenticationProviders to NTLM, is it possible that I am getting mixed up and...

These were the two little tidbits of information that helped us with the problem (one directly one indirectly):

Setting the NTAuthenticationProviders in IIS to NTLM was one of the things that...

K. Brian Kelley (12/11/2008)

---

Kevin Rathgeber (12/11/2008)

---

We worked directly with Microsoft and members their IIS team on this one (Brian Murphy-Booth and Christopher Haun to be exact). Every connection that...

K. Brian Kelley (12/11/2008)

---

Kevin Rathgeber (12/11/2008)

---

Maybe I have misread your article, but it seems to me you are saying NTLM will not work on multiple hops. We have in...

Maybe I have misread your article, but it seems to me you are saying NTLM will not work on multiple hops. We have in fact had this working using...

Got to love programming where the better of the two epiphanies was not reducing the number...

Kevin, why you need that IF at all?

There is an assignment right before the loop:

SET @item_category_counter = 1

If @loop_counter = 0 then @item_category_counter > @loop_counter and loop never got executed!

Isn't...

Just a quick comment about the table based.

Move @loop_counter out of the while into an IF statement outside the loop. Though its minimal, there is no point in running...

Besides the fact that the cursor solution is faster for the tests I performed, I do not see any advantage or disadvantage in using one solution or the other. ...

Thanks Jeff for that excellent in depth explanation.

As I explained to you privately my own personal brain fart made me miss an important piece of working with sets. Understanding...

I wanted to get some clearer results from what I had before. I am now on SQL 2005 Express. No one on the server but me. I...

Thanks Jeff. That was a good overview on the RBAR concept. Lucky for me I have tried to avoid that as much as possible. To tell you...