Microsoft SQL Server imposes the following restrictions when used as the primary database with Replication Agent:
Use of the TRUNCATE TABLE command on a table that has been marked for replication is forbidden.
Dropping a stored procedure that has been marked for replication is forbidden.
