Hi, can anyone please help me. I have a transaction replication i want to replicate all the transaction to the replication server except for delete transaction. How would I be able to handle this situation?
You would specify that in the article properties. Just unselect the delete option.
Take a look at this informative article https://www.mssqltips.com/sqlservertip/2520/options-to-not-replicate-sql-server-delete-commands/ this will show you step by step methods to not replicate SQL Server deleted command