If you want to do transactional replication, all the tables in the publication need to have a primary key. Here’s a quick way to determine which tables have a primary key.
This is the query for SQL 2005 and 2008:
SELECT so.name AS TableName, OBJECTPROPERTY(so.object_id, ‘TableHasPrimaryKey’) AS HasPrimaryKey
FROM sys.objects so
WHERE type = ‘U’
And here is the query [...]
Recent Comments