Search code examples
sql-serversql-server-2005replication

SQL Server replication without deletes?


Is there a way to replicate a sql server database but not push out deletes to the subscribers?


Solution

  • Do this....Drop the article. Create a new storedprocedure in the corresponding database that mimicks the system store procedure (sp_del...) and contains the same parameter but does nothing. Add the article again...and set the delete store procedure under the article's properties to the new delete stored procedure that you created....

    Or you can select Do not replicate Delete Statements....I think that works but i haven't tried it.