sql server replication: Warren,
try using sp_addscriptexec.
HTH,
Paul Ibison

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

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



[quoted text, click to view]

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




[quoted text, click to view]