table stuck in publication - SQL Server Forums

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

Import/Export (DTS) and Replication (2000)

table stuck in publication

Author

Topic

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-11-21 : 05:01:24

I have used the following commands to remove my table from being stuck in a publication. sql_tos being my DB and broker_employee being the table.

What does it mean though when in the BIT i've highlighted below the replinfo is equal to 3 ?? I was under the impression that it should be a 0 or 1. Just curious really. It worked anyway. thanks Paul.

sp_helparticle sql_tos, broker_employee

select object_id ('broker_employee')

select * from sysarticles
where objid = 1538820544

select category from sysobjects
where name = 'broker_employee'

select replinfo from sysobjects -- THIS BIT
where name = 'broker_employee'

sp_configure allow, 1

reconfigure with override

begin tran
update sysobjects
set replinfo = 0
where name = 'broker_employee'
commit tran

sp_configure allow, 0

reconfigure with override

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources