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.
| Author |
Topic |
|
JD78
Starting Member
2 Posts |
 Posted - 2008-07-15 : 09:15:31
|
| Hello, As you can see i am new to this forum so hello to everyone! I have an application that has been at my clients for about 2 years now. The database is SQL 2000 SP4 and the front end is a MS Access 2003 data project. Last friday (11/07/2008), data in a handfull of tables started to get set to null for no apparent reason. After using Redgate log explorer i identified that 4 tables had field values changed to null in 1 row only. This all happened between 09:54:27:7200 and 09:54:27:7700. This is not something a user has done because no-one has access to the backend. Also one of the tables is a key look up table that simply would and should not be changed. Business rules also prevent users from entering any null values. Has anyone ever experienced an error like this, is it a server error, SQL page error? I find it hard to believe a user could do all this within 200th of a millisecond!!ThanksJamie |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-07-15 : 11:03:17
|
| I've never heard of this but I'll share a story with you. Many moons ago "a programmer" wrote a script called 'lil bastard' that would delete 1 random row from a few tables at random times. The "random" of course followed some rules but to anyone from the outside looking in it was "random". The code was never run but "the programmer" had their finger on the trigger. Something to think about in your situation.Mike"oh, that monkey is going to pay" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 12:11:23
|
quote:
Originally posted by JD78
Hello, As you can see i am new to this forum so hello to everyone! I have an application that has been at my clients for about 2 years now. The database is SQL 2000 SP4 and the front end is a MS Access 2003 data project. Last friday (11/07/2008), data in a handfull of tables started to get set to null for no apparent reason. After using Redgate log explorer i identified that 4 tables had field values changed to null in 1 row only. This all happened between 09:54:27:7200 and 09:54:27:7700. This is not something a user has done because no-one has access to the backend. Also one of the tables is a key look up table that simply would and should not be changed. Business rules also prevent users from entering any null values. Has anyone ever experienced an error like this, is it a server error, SQL page error? I find it hard to believe a user could do all this within 200th of a millisecond!!ThanksJamie
there might be some triggers which causes the insert to table.You might want to look at triggers which references the table. |
|
|
|
JD78
Starting Member
2 Posts |
Posted - 2008-07-18 : 09:31:02
|
| Thnaks for the input but there are no Triggers in the application. Luckily it was only small amounts of data that went missing and it seems to have stopped happening now. Im thinking there was some kind of failure on the server for a split second. |
|
|
|
|
|
|
Random field values being set to null