drop replicated table?

[BikeBoy20032004]

Hi all,

Can I drop a table that's being replicated (transactional push replication) on SQL Server 2000 without deleting all the subscribers first? Is it possible to do something like sp_repldropcolumn with a table? s there a way?

Also, can I specify NOT NULL using sp_repladdcolumn procedure? The syntax is like:
sp_repladdcolumn @table = 'MyTable', @column='Column1', @typetext = 'int' NOT NULL

But that doesn't work.

Thanks a bunch

 

[JohnBates]

BikeBoy,

I think you have to delete the subscribers before you can drop an article/table. At least that has been my experience with both snapshot and transactional replication.

John

 

[BikeBoy20032004]

Thanks John, didn't think so, but never give up hope. Maybe in 2005