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!

No Comments