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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  SQL Compliance Manager Logging

Author  Topic  Al22 Starting Member 1 Post Posted - 2011-07-06 : 09:44:24 I have a DML Log for a database that I cannot reconcile to the actions performed. In my log I have 13 Insert statements as follows: Insert into FTPScheduleTable (Name) Values (@Name) Also I have one other insert statement below: Insert Into FTPScheduleTable (Name, type, days) Vaules (@Name, @type, @days) I also have 3 update statements. The three updates and the single insert statement I can account for because we copy a row that is similar to what we need, paste it into a new row, and update it accordingly. What I cannot account for are the 13 other insert statements for the Name. The actions performed do not align with these other insert statements and I was hoping that someone would have an idea of why these statements occurred. The record count is what it should be, only one addition for the row insert. Any help would be appreciated, I'm not sure if more info is needed. Thanks!!