Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Wrong entry in database
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 07/24/2013 :  11:28:19  Show Profile  Reply with Quote
Hello everyone,
Need some suggestions of experts :)

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.


James K
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 07/24/2013 :  12:04:07  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000