Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Find replicated tables and columns from system table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-01 : 09:49:26
question123 writes "I would like to know which system table contains the name of the replicated table and column. I tried sysarticles, it contains a field called DEST_TABLE, which works for the table portion, but the COLUMN field in system table sysarticles has datatype of varbinary(32), which doesn't tell the name of the replicated column.
Does anyone know if there's a simple way to find out from query analzer which tables and columns are being replicated?

Thanx in advance! :)"
   

- Advertisement -