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