I have an application that runs on Windows Server 2003 R2 with SQL Server. Client machines use the application (it appears it's installed on each client) and access a medical clinic customer management system database.
We are having trouble with some records showing that they are "open" when they are not.
The application software company has opined that one of our client machines is "broken" because if IT opens a customer record, thereafter the record appears to be already open to the other client machines.
Does this seem reasonable?
I can install Wireshark and look at packets in and out of the "culprit" machine but I have to wonder if SQL Server would allow a record to remain "open" if it isn't. Ditto whatever bit that shows that it's "open".
I know nothing about the implementation of the application and next to nothing about SQL Server.