sql server replication: cant drop rowguid or msrepl_tran

cant drop rowguid or msrepl_tran_version

ChrisR
7/28/2004 11:18:47 AM

sql server replication:

sql2k sp3

Ive got these columns on a previously replicated table and
I cant get rid of them. I went so far as to disable
Publisheing from the box and still no luck. I also removed
the default values and the indexes from them. I also tried
sp_repldropcolumn. Any ideas?

TIA, ChrisR

Re: cant drop rowguid or msrepl_tran_version

ChrisR
7/28/2004 12:29:11 PM

I appreciate the help. I had already run the
sp_MSunmarkreplinfo. I have dropped the Subscription db's.
And I ran sp_removedbreplication on the Publisher. I still
cant drop them. Any other ideas?

[quoted text, click to view]

Re: cant drop rowguid or msrepl_tran_version

Paul Ibison
7/28/2004 8:14:03 PM

Chris,
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.
HTH,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.