Hey,

We have recently written an app that will use the CMS API's to create blocks for us.  The application uses 

engine.Initialize();

When that is run the following stored procedure is called:

exec netContentTypeDelete @ContentTypeID=484

This stored procedure fails saying 

System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Looking at the stored procedure the problem is I have 7 duplicate guids in the table tblPropertyDefinitionType.  This is only on our production db.  Does anyone know how to solve this in a safe way?  I am not even sure what that tabel is used for.  I also have no idea why it is trying to delete that content type as it is valid.