Hello,
I'm trying to set up transactional replication from an SQL Server 2008 R2 instance to another.
The publication created using the wizard causes the snapshot agent to fail, with the error :
[...]Column [col name] in object FeaturedAgent contains type [col type], which is not supported in the target server version, SQL Server 2000[...]
I'm getting the same problem as the one is this post : replication failed on one table.
The solution in this post was :
Changing the publication database compatibility level to 100
But how to change the publication compatibility level for transactional publications ?
- The publication wizard only proposes to set the subscribers type for merge publications.
- And publication_compatibility_level property seems to be available only for sp_changemergepublication, not for sp_changepublication.
Thanks for any help or information.