Change the contraint on a published table

Hi,
Is it possible to remove/change a constraint on a table that has been
published, without reinitilising the subscriber?
Setup:
Merge Replication
Subscribers initiate a pull subscription
Kind Regards
Warren Patterson
Warren,
try using sp_addscriptexec.
HTH,
Paul Ibison
|||Hi Paul,
Thanks for your reply.
Unfortunately sp_addscriptexec is buggy and does not work via FTP. It would
solve my problem if it worked in my scenario, but unfortunately, the guys at
Microsoft told me that the reason sp_addscriptexec does not work via FTP is
due to the fact it tries to resolve the FTP address as a UNC path or
something like that.
Do a search in this news group for "Failed to apply script using 'osql'
utility (sp_addscriptexec)" I created a whole thread dedicated to this
issue.
Any other ideas?
Kind Regards
Warren Patterson
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eTa0DprXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Warren,
> try using sp_addscriptexec.
> HTH,
> Paul Ibison
>
|||Warren,
thanks for the info - found your thread on
http://www.mcse.ms/archive95-2004-5-641761.html.
If sp_addscriptexec doesn't work for your case, the only way I can see of
solving this issue is manually - linked servers, EM, QA etc
Regards,
Paul Ibison
|||Thanks Paul,
I was afraid that that was the only way.
Well, guess I need to make the 5000km+ round trip :-)
Kind Regards
Warren Patterson
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23UgfEE0XEHA.2940@.TK2MSFTNGP09.phx.gbl...
> Warren,
> thanks for the info - found your thread on
> http://www.mcse.ms/archive95-2004-5-641761.html.
> If sp_addscriptexec doesn't work for your case, the only way I can see of
> solving this issue is manually - linked servers, EM, QA etc
> Regards,
> Paul Ibison
>