Columns/tables not under Replication

Hai,
Can i find out the tables and columns which are not part of replication? is
there any Built in SP for this?
Thanks,
V.Boomessh
Hai,
there aren't any built-in sps for this. The tables you want to be concerned
with are sysobjects, sysarticles, sysmergearticles.
Something like this should do for the articles:
select table_name from information_schema.tables
where table_type = 'BASE TABLE'
and table_name not like 'sys%'
and table_name not like 'conflict_%'
and table_name not like 'msmerge_%'
and table_name not like 'mspub_%'
and table_name not like 'msdynamic_%'
and table_name not like 'msrep_%'
and table_name <> 'dtproperties'
and table_name not in (select name from sysmergearticles)
and table_name not in (select name from sysarticles)
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hai ,
Thanks for your reply.
[FYI: I am totally new to the replication].
Suppose if I add a table under replication and then add new columns to the
table, will these new column be a part of replication?
Also can u give me some good sites wherein i can get some basic stuff for
Replication.
Thanks,
V.Boomessh
"Paul Ibison" wrote:

> Hai,
> there aren't any built-in sps for this. The tables you want to be concerned
> with are sysobjects, sysarticles, sysmergearticles.
> Something like this should do for the articles:
> select table_name from information_schema.tables
> where table_type = 'BASE TABLE'
> and table_name not like 'sys%'
> and table_name not like 'conflict_%'
> and table_name not like 'msmerge_%'
> and table_name not like 'mspub_%'
> and table_name not like 'msdynamic_%'
> and table_name not like 'msrep_%'
> and table_name <> 'dtproperties'
> and table_name not in (select name from sysmergearticles)
> and table_name not in (select name from sysarticles)
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||To add a new column, have a look at sp_repladdcolumn in BOL, or it can be
done through the GUI. For a completely unbiased view of an excellent site,
have a look at www.replicationanswers.com It isn't an attempt to cover
all the ins-and-outs of replication, more a covering of the exceptions and
articles mostly based on what is found to be difficult setups. If you want a
comprehensive coverage of replication, buy Hilary's book - details below.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)