Is there a way to create a procedure possibly that we can delete data in a database that has been replicated to another server's database without it replicating the deletions on the replicated server? If so, how in SQL Server 2005? We are wanting our front-end sql server to handle all the load, then replicate to our second front-end database server for reporting and/or failover. We are also wanting to replicate our 2nd database server to a third for failover purposes. Any help you can give me would be greatly appreciated!!