DotNetNuke Developer Chris Hammond

DotNetNuke Core Team Member

News

Thanks for visiting my blog, you can find more about me at ChrisHammond.com or on my company's website at Engage Software.

Cool Sites

My domains

Projects

Remove table from Sql Replication

I've been having problems removing a few tables from SQL replication, so yesterday I just removed the replication process completely.

That didn't help! So I dug and dug through the master tables, tempdb, and anywhere else I could think of to try to figure out why these particular tables said they were still being replicated.

Finally I posted on the microsoft.public.sqlserver.replication newsgroup and got the fix.

sp_MSunmarkreplinfo    'TableName'

Thanks to Hilary Cotter for helping me out with that!

Posted: Mar 17 2004, 03:17 PM by Chris Hammond | with 2 comment(s)
Filed under:

Comments

TrackBack said:

You have been Taken Out! Comments about your post on this link. Thanks!
# March 18, 2004 12:03 AM

Shiva Kumar said:

Fantastic! This was a long standing problem for me when I restored the "replicating database" backup to work on testing. This works!!!

# December 11, 2007 7:36 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)