Search the Community

SCCM 2012 SP1 Beta SQL 2012 Server 2012 Stand alone primary I am NOT a SQL guy and I am getting a persistent and vague error on my sccm 2012 server. "Microsoft SQL Server reported SQL message 8672, severity 16: [42000][8672][Microsoft] [sql Server]The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the" Message ID: 620Process ID: 2232Thread ID: 4920 I get an error about every 6 minutes or so. What I have read so far indicates a possible duplication in a table somewhere. What my SQL people have told me is "looks like there's an error somewhere". Then tell me you have to know the table your looking for and that even if you find it there will be nothing obvious to tell you what needs to be fixed let alone HOW to fix it. So, I'm super stuck. I know next to nothing about SQL, but if some one has seen this before, if you could help me out that would be great! I have tried simply clearing the counter. I'm sure you can imagine how much that helped. Thanks,