Microsoft SQL Server imposes these restrictions 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.
-
Replication Agent does not support some functionality for Microsoft SQL
Server 2008.