How to find replicated columns in published article

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / Other Technologies / Replication / March 2006

How to find replicated columns in published article

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 30 Mar 2006 04:40 GMT

SQL 2000 trans replication.

I have a fat table (100+ columns ) being replicated minus a couple columns. .

How do I query the replication sys tables to find all columns being
replicated? Goal is to find which columns are NOT replicated.

Thanks in advance,
Chris

Reply to this Message

Paul Ibison - 30 Mar 2006 10:29 GMT

Chris,
sp_helparticlecolumns and the published bit will do the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.