I am running a database on compatibility level 80 because the application using it does not yet support a higher level.
It is my understanding that transactional replication on SQL Server 2005 and up has some new features like schema changes replication and improved schema locking.
Can I benefit from these new features if my database is on a lower compatibility level?
In other words, do these features depend on the compatibility level of the published database or does this rely only on the version of the server? I know merge replication has a publication compatibility level (independent from database compatibility level) but I can't find a clear answer about transactional replication.
Best Answer
The short answer is Yes they do depend but to a certain extent only.
Compatibility level can have an affect on the publishing and subscribing databases, with respect to object ownership and the existence (or not) of a particular schema.
Also, have a look at sp_vupgrade_replication
From BOL:
Refer to :