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
No comments:
Post a Comment