New table not showing up in article list

[Darleen]

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.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/

[Ben Thul]

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

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.
Fromhttp://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com/g/