How to replicate 2 tables in differente schema but with the same name
hi, how can replicate 2 tables same name indifferent schema(arq.tst, dbo.tst). getting error trying replicate 2 tables database. there way that? there minor problem doing gui. you must manually define stored proc names. default names gui ignore the "destination owner schema" name , use "dbo.sp_msxxx_dbo" proc names. cause 2nd stored proc overwrite first, , update 2nd table. SQL Server > SQL Server Replication