Showing posts with label pls. Show all posts
Showing posts with label pls. Show all posts

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)