No. Either the tables have primary keys or they don't.
This query will show you tables that don't have Primary Keys
SELECT schema_name(t.schema_id) [schema], t.name [table]
FROM sys.tables t
LEFT JOIN
INFORMATION_SCHEMA.TABLE_CONSTRAINTS c
On schema_name(t.schema_id) = c.table_schema
And t.name = c.table_name
And c.constraint_type = 'PRIMARY KEY'
WHERE c.table_name is null;
Transactional vs snapshot replication
Posted - 08/07/2012 : 17:04:41
