0

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!

|improve this question
  • Assuming you are talking 2008 R2 instances and you are running a DB in 2000 compatibility mode, it sounds as though you have an object with a Date data type. Since that's a 2008 data type, you are probably hosed at the publisher. Break replication, fix the data type in the intended publisher DB and redefine your articles. – Steve Mangiameli Nov 3 '14 at 20:34
  • @SteveMangiameli: the thing is; from what I was told, the application which accesses this DB is a legacy ASP which makes extensive use of SQL2000 legacy syntax (e.g. "*=" instead of " outer join") and that's why they have to keep it under compatibility mode. That said, it seems they have created SQL2008 data types, so it's quite a mess. Not sure if I am making sense (SQL Server is not in my 'comfort zone'). Would I be able to create a SQL2008 data type and use SQL2000 syntax? – Pbal Nov 5 '14 at 13:27
  • No sir, compatibility mode enforces the rules/syntax of the version you've set. You just need to change the data type and update the code that references it. Hopefully, it's not too extensive. – Steve Mangiameli Nov 5 '14 at 17:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.