Hi All,
Can someone tell me ways of determining whether a table is marked for replication?

rasu90 (AT) yahoo (DOT) com (Raj) writes:

Connect to the database used by the replication server and say
something like

select o.phys_tablename,
to_database.dsname,
to_database.dbname
from rs_objects o,
rs_databases from_database,
rs_subscriptions s,
rs_databases to_database
where o.dbid = from_database.dbid
and o.objid = s.objid
and s.dbid = to_database.dbid
and from_database.dsname = 'MY_SERVER'
and from_database.dbname = 'my_database'

This will tell you all the tables in my_database that have replication
subscriptions and where they're being replicated to.

--
Ed Avis <ed (AT) membled (DOT) com>

rasu90 (AT) yahoo (DOT) com (Raj) wrote in message news:<5d364c3b.0312240130.381c1dbc (AT) posting (DOT) google.com>...
I'm out of the office so I can't look this up right now, but
I believe there is a bit in the sysstat or sysstat2 column
of sysobjects that indicates replication. To find out which
one, create a table, look at the values, mark the table for
replication, check the values again.

-bret

sp_setreptable displays a list of tables that are replicated. It will only
set a table to replicate if you give it 2 arguments
ie: sp_setreptable 'table1','true'
but don't do that unless you work closely with your DBA.


1> sp_setreptable
2> go
Name Repdef Mode
------------------------------ -----------
rep_t owner_off

(1 row affected)
(return status = 0)
1> sp_setreptable rep_t
2> go
The replication status for 'rep_t' is currently true, owner_off.
(return status = 0)
1>


Karl



"Raj" <rasu90 (AT) yahoo (DOT) com> wrote