SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

pr0t0c0l
Starting Member

India
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.

Thanks

James K
Flowing Fount of Yak Knowledge

3760 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  
 New 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.03 seconds. Powered By: Snitz Forums 2000