ERROR MESAGGE:
“Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203
Caught error#: 2627, Level: 14, State: 1, in Procedure: sp_syscollector_create_collection_set, Line: 137, with Message: Violation of UNIQUE KEY constraint ‘UQ_syscollector_collection_sets_internal_name’. Cannot insert duplicate key in object ‘dbo.syscollector_collection_sets_internal’.”
EXPLANATION:
In SQL Server 2008, you may experience such an error when you want to create a Collection Set by using the “sp_syscollector_create_collection_set” Stored Procedure.
The reason for this is that you have a Collection Set that has the same name as the Collection Set you are trying to create.
SOLUTION:
Create a collection set with a different name.
