Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
New table not showing up in article list
2 views
Skip to first unread message
Darleen
Aug 19, 2010, 11:25:10 AM8/19/10
to
Forgive me I'm very new to SQL Server. I just had someone transfer my entire database from Access to SQL Server and I'm trying to get up to speed.
It is a merge replicated database.
I added a new table "EmailList" to the database "CRM", then went to the "CRM" Publisher properties in SMSS and noticed that when I expand the article list, my new table is not there for me to specify as an object to publish.
I need this new table to be replicated to all subscribers. How do I get it to show in the article list so that I can check it and have it replicate? I tried creating a new snapshot, but that didn't work.
From http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
Ben Thul
Aug 19, 2010, 12:28:15 PM8/19/10
to
Does your table have a primary key? This is a prerequisite for a
table to be an article in replication. See http://msdn.microsoft.com/en-us/library/ms151254.aspx
for other considerations.
--
Ben
table to be an article in replication. See http://msdn.microsoft.com/en-us/library/ms151254.aspx
for other considerations.
--
Ben
0 new messages