SQL Server Replication (SSQA.net)

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as Read More...

Replication FAQ series - Which objects in the database are published?

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1 union select name as published_object, schema_id, Read More...