Incorrect entries in db

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hello everyone,
Struck with a unique problem.

I am using sql server management studio 2005
Have dot net web application to which db is connected.

Actually I have a database on production in which wrong entries are getting inserted from somewhere. I have debugged whole code and checked the stored procedure as well but all went well when I am manually executing stored procs with parameters. Correct values are getting inserted in db.
But I can clearly check the wrong entries in 1 of the table but have no clue from where they are coming into the db

Can anyone give some suggestion so as to diagnose the issue.
Any suggestion will be helpful.

Thanks

Posted 24-Jul-13 5:37am

prot0col

Add a Solution

Comments

Prasad Khandekar 24-Jul-13 11:45am

Have you checked the triggers? Also check your code and ensure that you are using SQLCommand and bind parameters everywhere. It might be the case of SQLInjection as well.

Regards,

ZurdoDev 24-Jul-13 12:09pm

I would suggest you post as the solution.

[no name] 24-Jul-13 12:11pm

Hi Prasad, My application is internal application for the client so probability of sql injection is very lean.

Prasad Khandekar 25-Jul-13 9:38am

Well that does not rules out the possibility. I develop softwares for FI's and most of the controls and checks are actually implemented on internal apps. Since you yourself have not created any entries it might also be possible that some one knowing the db credentials actually inserted then using an SQL client.

[no name] 24-Jul-13 11:47am

http://msdn.microsoft.com/en-us/library/cc280386.aspx[^]

[no name] 24-Jul-13 12:11pm

Hi ThePhantomUpvoter Thanks for sharing the link. That seems to be a lot of work. I will keep it as the same option. :)

ZurdoDev 24-Jul-13 12:09pm

You need to reply to the comment so that the user is notified. Don't add a new comment to your own question.

[no name] 24-Jul-13 12:10pm

ohk.
Thanks for the suggestion, will do that from now onwards.

ZurdoDev 24-Jul-13 12:12pm

But Prasad is right. You have to look at triggers and search your entire code for that table and see what is inserting the data. You could also buy an auditing tool.

[no name] 24-Jul-13 12:28pm

There are no triggers and yes I have searched all the stored procedures which are updating, deleting or inserting the values in that table but neither of the stored proc. seems to be buggy.

ArunRajendra 25-Jul-13 0:06am

If possible can post a wrong entry data and the reason why the entry is not expected?

[no name] 26-Jul-13 14:19pm

Actually we have one table in which we store activity name for peoples. For each person only activity name can be there so if some one wants to change his/her activity we deletes the old one and insert new one thats the logic we have in all the stored procedures for that table but I are seeing 2 or more than 2 entries for the same person in the same table. When we are trying to reproduce the same issue we are unable to do that as everything works fine.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)