sql server replication: The views in my database are articles within the publication of this
database. If I make changes to these views - with alter view , or in
design mode - these changes aren't uploaded to the subscriber after a sync.



Does anyone know how I can force a view update at the subscribers database?



Thanks in advance

René

Hi René,

Thanks for your post. According to your description, I am not sure what
your problem is. I would like you to provide more information so that I can
narrow down this issue.
1. What is the version of SQL Server (Service Pack)?
2. What is the kind of the replication on your side? Also, what is the kind
of subscription?
3. Do you mean that you change the schema of the view and the changes are
not replicated to the subscriber? If so, I would like to know if the
subscription is scheduled or it is set as "continuously"?
4. Did any error message occur on your side? In other words, did any agent
fail?

For more information regarding this issue, please refer to the following
article on SQL Server Books Online.
Topic: "Schema Changes on Publication Databases"

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

its not possible to modify the schema of views that are=20
replicated and send these updates to your subscibers.=20

You might want to look at sp_addscriptexec to drop and=20
recreate views on your subscibers. You run this on your=20
publisher and all the subscribers will get your=20
modifications.
[quoted text, click to view]