SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Dec 11, 2007.

  1. Anonymous New Member

    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 published_column from sys.columns where is_replicated = 1 --For merge publications select object_name(object_id) as merge_published_table, name as published_column from sys.columns where is_merge_published = 1...(<a href="http://sqlserver-qa.net/blogs/replication/archive/2007/12/11/2907.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2907" width="1" height="1">

Share This Page