The texts in my database are closed [closed]

Navigation
0

I have a database in SQLServer 2005, and a couple of months ago in 2 tables we started to cut some records in a random way, I mean.

If in a field before it said "hello world", nowadays it says "hello mu" or "hol". The strangest thing is that the cut of the length of characters is random and not for all the records.

What do you recommend doing to find out the reason for this? Thanks in advance.

    
asked by Alejandro Patricio Cofré Lorca 26.05.2017 в 22:37
source

1 answer

1

This as you mention it may be due to an involuntary or voluntary "bug" of the system. To detect if it is an error in the system as you commented, check Sp's, Triggers and source code in general looking for any UPDATE operation on the table. If this is a big task because you do not have control over all the routines that update the table, a trick you could implement would be to incorporate an UPDATE trigger to the table and:

  • Check if the column in question is being modified
  • If the length of the new value is less than the original, but the new value is included in the original value (eg "Hello M" is included in "Hello World") it would generate a record in a log table. You can register time, hostname, user, etc.
  • With that information I would do an analysis and survey with the user to see what process was running.

    • The problem can be a valid error or a malicious event, with the record of these events you can at least start a follow-up.

        
    answered by 26.05.2017 в 23:18
    As I can see step by step a method with Debug [closed] Leave a default value in a ComboBox