Reseed the Marketing Campaign Database

Error Message:

An exception occurred in the 'MarketingWebService' Web service. Exception details follow:

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__mktg_cam__93C9A4F145F365D3'. Cannot insert duplicate key in object 'dbo.mktg_campaign_item'.

The statement has been terminated.

Solution:

Execute this query against the marketing database, change the 35 to whatever value you need.

DBCC CHECKIDENT (mktg_campaign_item, reseed, 35)

Checking identity information: current identity value '27', current column value '35'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Explination:

This happens to me when i sync databases using Redgate SQL Data Compare. It's a quick fix and should work fine.