Hi,

How can I modify table with publication (change of one column length)
without completely breaking replication.

Thanks in advance

"Wagner" <wagner@email.t-com.hr> wrote in message
news:1x0k6ml5is0vs$.mmdq6nunj5l6$.dlg@40tude.net.. .
> Hi,
>
> How can I modify table with publication (change of one column length)
> without completely breaking replication.

Besides the method you found, I've also done the following:

Create a NEW column of the type you want, call it foo_temp.

Copy data into it.

Then sp_repldropcolumn on the existing column.

Then sp_repladdcolumn with the same name, but new definition.

Copy data back.


>
> Thanks in advance