Transactional Replication Articles

Question

I created a publisher then the subscription.  it created the data base but there are no tables that i choose to replicate.  I am quite confused and i even deleted both and started from scratch but the exact same thing is happening,

Can anyone help.  I have to get this working tonight.

Answer 1

These tables likely don't have primary keys on them.

First off check you can see them in query analyzer in the publication database.

select * from sys.objects where type='U'

Then check that they have PKs.

SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 1
ORDER BY SchemaName, TableName

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941