473,326 Members | 2,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

SQLserver on SBS2003 returns old data


SQLserver on Small Business Server for Win 2003.
Client application updates records in DB. i.e. the content of a field is
updated from "First" to "Second"
Client application closed and opend again. DB returns value "Second".
Next morning _SOME_ - not all - of the updates seems missing. DB returns
the value "First"

The client software has run for years i several thousand installations,
with MSDE/SQLserver on w2k and 2003 servers.
This is the first time we have seen this spooky behavior. And it is the
first time we are targeting SBS.

Could there be some unflushed cache between client and SQLserver?
Poul Petersen
Jun 28 '06 #1
1 1554
Poul Petersen (ps*@tech-p.dk) writes:
SQLserver on Small Business Server for Win 2003.
Client application updates records in DB. i.e. the content of a field is
updated from "First" to "Second"
Client application closed and opend again. DB returns value "Second".
Next morning _SOME_ - not all - of the updates seems missing. DB returns
the value "First"

The client software has run for years i several thousand installations,
with MSDE/SQLserver on w2k and 2003 servers.
This is the first time we have seen this spooky behavior. And it is the
first time we are targeting SBS.

Could there be some unflushed cache between client and SQLserver?


No.

I don't know much about SBS, but I've never heard anything that SBS
would come with some special version of SQL Server.

This behaviour typically has two explanations:
1) Poorly handled query timeouts. If a query times out, no transaction
is rolled back automatically. If the client does not handle this
appropriately, the user may jog along all day with an open transaction.
When he logs out, everything is rolled back.

2) There is simply a process that performs an update in the other
direction.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 28 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Bart Torbert | last post by:
Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the...
3
by: Devonish | last post by:
I am planning to convert an existing Access database which has a back end (data tables and relationships only) on a server and a copy of the front end (form, queries, reports) on each of about a...
14
by: Roy Gourgi | last post by:
Hi, I need to store and retrieve information from a database. It looks as though there is a lot more support for SQLServer than there is for Access, correct me if I am wrong. What do I have...
8
by: karahan celikel | last post by:
I realized that when SqlServer mode is used for session management Session_End event is not fired in global.asax. What can I do if I want to do something when a user's session end? Thanks
2
by: SubstandardSnowman | last post by:
When I'm trying to deploy an ASP.Net app to Small Business Server 2003 I can't allow the ASPNET user access to the directory because it isn't found in active directory. I have run aspnet_regiis.exe...
0
by: Brian Smither | last post by:
I have SBS2003-SP1 (with MSDE) installed. I have read several "How-To's" on upgrading MSDE to 2K5Express, but none have directly answered the SBS2003/MSDE install scenario: is MSDE a "module" of...
1
by: Tony Girgenti | last post by:
Hello. I developed and tested a web application using VS.NET 2003, VB, .NET Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. It uses a web form. When i go to client site, if they have their...
1
by: Darsin | last post by:
Hi, I have three tables with there fields given in brackets: User: (PK), Divisions: (PK), DivisionsOfUsers: , the "DivisionsOfUsers" tables has many-to-many relationships between userid...
0
by: Rob | last post by:
I have a Webservice written in C# that provides data to both a web browser through ASP.net and to a VC++ client. I have been able to retrieve data from SQLServer and passing to my C++ client as...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.