Chris Hammond

Director of Training Programs for DotNetNuke Corporation

News

Thanks for visiting my blog, you can find more about me at ChrisHammond.com. I am the Director of Training Programs for DotNetNuke Corporation.

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