title: Replicating Stored Prcoedures
body: <p>I've been looking around on-line for an answer to this one but to no avail!</p>
  
  <p>Is it possible to replicate a stored procedure which has a read-only user defined table type as a parameter?</p>
  
  <p>For example:</p>
  
  <pre><code>CREATE TYPE [UTIL].[DATE_TIME_LIST] AS TABLE (
      [ID] UNIQUEIDENTIFIER ,
      [START_DATE_TIME] DATETIME,
      [END_DATE_TIME] DATETIME
  )
  GO
  
  --Publisher Side
  CREATE PROCEDURE DBO.REPLICATION_TEST 
      (@REPLICATED_OBJECT UTIL.[DATE_TIME_LIST] READONLY)
  AS 
  BEGIN
      RETURN 
  END
  
  --Subscriber Side
  CREATE PROCEDURE DBO.REPLICATION_TEST 
      (@REPLICATED_OBJECT UTIL.[DATE_TIME_LIST] READONLY)
  AS 
  BEGIN
      INSERT INTO DBO.LOGGING_TABLE (ID, START_DATE_TIME, END_DATE_TIME)
         SELECT 
             ID, START_DATE_TIME, END_DATE_TIME 
         FROM @REPLICATED_OBJECT
  
      RETURN 
  END
  </code></pre>
  
  <p>I would assume you'd need the custom table type on both Publisher and Subscriber databases.</p>
  
  <p>Thanks.</p>