By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

Altering table & trans. replication

P: n/a
Hi,

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

Thanks in advance
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Wagner" <wa****@email.t-com.hr> wrote in message
news:1x******************************@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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.