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 |
|
pr0t0c0l
Starting Member
1 Post |
 Posted - 2013-07-24 : 11:28:19
|
| Hello everyone,Need some suggestions of experts :)I am using sql server management studio 2005Have 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 dbCan anyone give some suggestion so as to diagnose the issue.Any suggestion will be helpful.Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-24 : 12:04:07
|
| Couple of options:1. Run Profiler (or trace) and filter for just the statements that affect the table. Then correlate the info from the profiler against the incorrect entries in the table.2. Add a trigger to the table on inserts to capture information about the user, timestamp etc. |
 |
|
|
|
|
|
Wrong entry in database