Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2010-05-19 : 14:38:21
|
| I have a transactional replication publication that includes stored procedures as articles. The ALTER PROC statement on the publisher is not causing the schema change to propagate to the subscribers. According to MS (http://msdn.microsoft.com/en-us/library/ms147331.aspx) the schema change should flow out to everyone.I have verified that the Schema Replication option has been set to True for the article. sp_HelpArticle reports that Schema_Option = 0x8000001.This is a complete SQL 2008 to SQL 2008 environment.Does anyone have any insight into whether this option does work or if there are any special configuration details that need to be adhered to?Many thanks...=======================================A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007) |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-05-20 : 11:20:24
|
| Anyone? Anyone? Bueller?=======================================A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007) |
 |
|
|
|
|
|
Replication: ALTER PROC not propagating