Systems problem
Home > IT Answers > Development > Systems problem
Jdcruz
10 pts.
0
Q:
Systems problem
SQL, SQL Server, VB
I always wonder why this happened to my system.....a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is......they notice that in no particular time there are data that are deleted automatically inside my database. There are times but not frequent it happens. I review my codes and all delete commands to my SQL are in ordered properly....I also put some codes to trap if someone intentionally do this but found out nothing. If this happened could it be related to my SQL Server database? I could not figure out whats the problem. If someone have an idea about this please post a reply. By the way I am using VB6 language and SQL server 7 for my database. Thanks everyone in advance and God Bless.
ASKED: Oct 24 2007  3:11 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Data only gets deleted for one reason. Someone is deleting the data. If it's not happening through your application, perhaps someone is logging directly into the database and deleteing the data. Put a delete trigger on the table which logs all deleted data into a logging table. Be sure to include the username of the person doing the deleting. The next time someone says that the data has been deleted find the row(s) in the log table and see who deleted them.
Last Answered: Dec 2 2007  11:21 AM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0