Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  MSDE (2000)  locking breaks

Author  Topic  strings Starting Member 1 Post Posted - 2006-03-08 : 09:59:29 Hi, I have 10 environments of up to 10 clients to one data server(MSDE 2000 SP4), accessing data through concurrent transactions over OLEDB. Each operation on each transaction is using lock, so they will access by order of processing. the problem is that in two of those environments, the data server had some situations of nolock. I thought, when it first occured, that it was a problem of low resources(PENTIUM 1.6Ghz 512MbRam), and that was the answer of SQL Server because of the dynamic lock. I've changed this configuration to specific limitation of locks, and other configurations, but it continnued until the substitution of that machine (PENTIUM 3.6Mhz 2GMbRam). Recently, I've installed a new environment, and the data server (P4 3.0Ghz 1GbRam)started doing the same thing. Those situations occur rarely. Can anyone help me?? Could it be some hardware conflict??? Antivirus?? Windows XP??? The main question is: "When or why does SQL Server ignore the need of locking transaction statements??"