Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Replication (SSQA.net)

Another methodology to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
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 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

Posted: Tuesday, December 11, 2007 5:48 PM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

Here is script you can find which columns are published in the replication that is using either snapshot

# December 11, 2007 5:51 PM

SSQA.net - SqlServer-QA.net said:

Here is script you can find which columns are published in the replication that is using either snapshot

# December 11, 2007 6:42 PM
Anonymous comments are disabled