Cannot insert record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben - 28 Oct 2006 12:48 GMT

Hi,

I am getting the following error when trying to insert a record into a table
at a subscriber.

Table '[dbo].[Customer]' into which you are trying to insert, update, or
delete data is currently being upgraded or initialized for merge replication.

I droped replication at suibscriber and tried to insert a record, and I
still got the error.

Help will be greatly appreaciated.

Thanks

Ben

Reply to this Message

Paul Ibison - 30 Oct 2006 10:47 GMT

Ben,
at the subscriber if there are no other subscriptions in this database can
you run sp_removedbreplication and also check the Customer table to see if
there are any remaining triggers on it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

Ben - 31 Oct 2006 03:55 GMT

Paul,

The stored produre below did the job!

Thank you very much!

Ben

> Ben,
> at the subscriber if there are no other subscriptions in this database can
> you run sp_removedbreplication and also check the Customer table to see if
> there are any remaining triggers on it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message