Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203

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.