Forum Discussion

rmanj9210's avatar
rmanj9210
Copper Contributor
Apr 25, 2024

SQL Server 2022 Replication

Is Merge Replication 2022 supported to execute stored procedue?

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 25, 2024
    Your post/question is very unclear.
    (Merge) Replication is transfer object design and data.
    If you want to execute scheduled a stored procedure, then create an agent job for.
    • rmanj9210's avatar
      rmanj9210
      Copper Contributor
      Apr 26, 2024

      olafhelper 

       

      The requirements is to replicate the data by using stored procedure.

       

      I tried to configure merge replication. i have seen that there is no option to execute the stored procedure. The reason why they need to use stored proc is to get the data from multiple tables and not from one table only.

       

      Please advise/suggest.

       

      Thanks

      Ruel

       

Resources