Tuesday, February 21, 2012

Replication hold on table artcl after its publication had been dro

Pls help with my issue. I have a table that was an article in a publication.
However the publication to which the article belongs had been dropped but I
stoll get the following error message when I try to truncate the table. What
is goin on ?
"Cannot truncate table 'tblContributorRole' because it is published for
replication."
There is a stored procedure to do this called sp_MSunmarkreplinfo which
takes a tablename as a parameter. Alternatively, setting replinfo to 0 in
sysobjects for the particular table should do it. Finally, running
sp_removedbreplication can be used to remove all traces of replication in
the subscriber database, but obviously must only be done if this database is
not also configured as a publisher.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment