|
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
Navigation:
[Reply to this message]
|