I have 2 SQL Server 2008 R2 and I am trying to set up Snapshot Replication over the Internet. I have successfully managed to get the subscriber to connect, but now as the Job executes on the PUBLISHER, I am getting the following error:
Target Site: VoidCheckSupportedType(Microsoft.SqlServer.Management.Smo.ScriptingOptions)
Message: Column EmissaoCRV in object Prodesp_Movimento contains type Date,
which is not supported in the target server version, SQL Server 2000.
Both databases (published and subscriber) are configured as "Compatibility Level SQL 2000". That said, I have tried to change the Subscriber Compatibility Level to 2008, but it didn't work.
Any ideas? Thanks in advance!