Systems problem

10 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following