Restore of Replicated Database fails with “Cannot drop the table  because it is being used for replication.”
Use below query to avoid replication related SP in Transactional Replication.

SELECT name 'ROUTINE_NAME','T' 'ROUTINE_TYPE'
            FROM sys.tables 
            WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 1 AND name not like 'MSpeer%'