Hello,

How do I do to resize a column in a replicatied table on the publisher,
without dropping curent replication ?

Philippe,
assuming the question concerns sql server 2000:
http://www.replicationanswers.com/AddColumn.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi Philippe - this can't be used to resize a column directly, but does form
part of the workaround solution:

exec sp_repladdcolumn @source_object = 'tEmployees'
, @column = 'TempForename'
, @typetext = 'varchar(100) NULL'
, @publication_to_add = 'tTestFNames'

update tEmployees set TempForename = Forename

exec sp_repldropcolumn @source_object = 'tEmployees'
, @column = 'Forename'

exec sp_repladdcolumn @source_object = 'tEmployees'
, @column = 'Forename'
, @typetext = 'varchar(100) NULL'
, @publication_to_add = 'tTestFNames'

update tEmployees set Forename = TempForename

exec sp_repldropcolumn @source_object = 'tEmployees'
, @column = 'TempForename'


NB this is VERY easy in SQL Server 2005, where Alter Table on the publisher
is sufficient :)

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Use sp_repl_add_column

[quoted text, click to view]