Posted by Greg D. Moore \(Strider\) on 10/22/07 11:19

"bmm" <bmmsletdetteher@comlog.dk> wrote in message
news:471c56d4$0$15891$edfadb0f@dtext01.news.tele.dk...
>I have a Store Procedure on a Sql Server 2000 Where I use the Table Hint
>"NoLock" on all selects.
>
> One of my clients (OleDbConnection from C#) doesn't get the same Result
> Set as the others. The result Set should have 31 rows but this client only
> gets 5!

Since you said "others" I'm a bit confused. If you had said ONE other got
31 and everyone else was getting 5 I'd say that makes perfect sense due to
how transactions work and how (nolock) works. (i.e. my guess would be you
have an open transaction someplace).


>
> When I remove all the "NoLocks" everything works fine. How can that be?

In this case, off the top of my head, I can't quite figure out the scenario
that would give this behavior).


>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]