Saturday, February 25, 2012
Records lost on database
Replication occurs every ten minutes. A problem occurs when they capture
employee information through a web application affecting several tables that
the information in some of the tables "disappears". What would be the best
way for me to investigate what the problem could be?
It depends on how the info was added. If it is a bulk insert, or a fast load
from DTS, then the replication triggers won't fire by default, and the data
will be left on one side only. Is that what you're seeing? If it is instead
that data is successfully added then disappears, it might be that you have
compensating changes occurring
(http://support.microsoft.com/default.aspx?scid=kb;en-us;828637&Product=sql2k).
Cheers,
Paul
Records Duplicate when edited...?
Hi,
I have written a web application using dreamweaver MX, asp.net, and MSsql server 2005.
The problem I am having occurs when I attempt to edit a record. I have setup a datagrid with freeform fields so that the user can click on edit, make the required changes within the data grid then click update. The data is then saved to the database. All this was created using dreameaver and most of the code was automatically generated for me.
The problem is that, not everytime, but sometimes when I go to edit a record once I hit the update button to save the changes the record is duplicated 1 or more times. This doesnt happen everytime but when it does it duplicates the record between 1 and about 5 times. I have double checked everything but cannot find anything obvious that may be causing this issue.
Does anyone have any suggestions as to what I should look for? Is this a coding error or something wrong with MSsql? Any ideas?
Thanks in advance
-Mitch