Replication Script

-- Simple script showing tables without PKs - useful for Transactional Replication

select * from information_schema.tables
where table_type = 'base table'
and objectproperty(object_id(table_name),'IsMsShipped') = 0
and objectproperty(object_id(table_name),'TableHasPrimaryKey') = 0