title: Web Sync Replication: (0x80004005): The schema script 'xxx' could not be propagated to the subscriber
body: <p>Ive been having great trouble setting up replication (web sync via HTTPS).</p>
  
  <p>If I only publish the tables, they replicate fine with the data.</p>
  
  <p>If I add in views &amp; sprocs then it failes with the message:</p>
  
  <pre><code>ComErrorException (0x80004005): The schema script 'xxx' could not be propagated to the subscriber
  </code></pre>
  
  <p>The publication is SQL 2008 and the subscriber is SQL Express 2005.</p>
  
  <p>The views are all relativly simple, such as: (SQL added the DROP at the top).</p>
  
  <p>drop View [dbo].[vAllUsers]
  go</p>
  
  <p>SET QUOTED_IDENTIFIER ON
  go
  SET ANSI_NULLS ON
  go</p>
  
  <p>CREATE VIEW [dbo].[vAllUsers] AS
  SELECT     userid
  FROM         staff
  WHERE     userid IS NOT NULL
  UNION all
  SELECT     userid
  FROM         vesselstaff
  WHERE     userid IS NOT NULL
  UNION all
  SELECT     userid
  FROM         fleetmanagers
  WHERE     userid IS NOT NULL
  go</p>
  
  <p>Im confused and basically dont know what Im doing. Does anyone have any ideas????</p>
  
  <h1>Update 3rd Dec 10</h1>
  
  <p>Ok, I've been fiddling with this for a bit longer. It does replicate the tables, data and user defined functions but no stored procedures or views will go. What does this indicate?</p>