Duplication of associations superclass contraints and more in TMCore07 SP3
EPiServer site with TMCore:
TMCore07 SP3 and TEM v2.3
During either the convertion from TMCore07 SP1 to SP3 or when I wanted to see what happend when I clicked the Generate Schema button in the Topic map editor, many of the associations got duplicated. In the tmcore database there is a stored prodecure called tm_RemoveDuplicates, that cleans this mess up. For a long time I was wondering if the duplications where supposed to be there, but running this script clarified everything.
USE [dbDatabasenavn]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[tm_RemoveDuplicates]
SELECT 'Return Value' = @return_value