SQL Server 2000
I have a table being replicated named owner.MyTable on the Source DB and dbo.MyTable on the Destination DB.
Do I have go through
drop_subscription ...
drop_Article ...
Add_article ...
Add-Subscription ..
EXEC sp_refreshsubscriptions
SNAPSHOT
or can I just do a new Add_Subscription and have the owner.MyTable Database published as owner.MyTable AND db.MYTable?