Re: Error 207

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jakob Brøckner (anonymous_at_discussions.microsoft.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 01:05:48 -0700

I have already recreated the publication with same error.

/Jakob Brøckner
>-----Original Message-----
>I think your best idea is to recreate the publication -
SQL 2000 is sending
>some new parameters that were not around in SQL 7
>
>"Jakob Brøckner" <jb@visual.as> wrote in message
>news:052301c47fb7$05f48470$7d02280a@phx.gbl...
>Hi everyone,
>
>I am trying to create a Transactional Pull Subscription
>but I get an error 207 : Invalid column
>name "enabled_for_syncmgr"
>Invalid columnname "alt_snapshot_folder"
>Invalid columnname "dts_package_name".
>
>Both The Publication and Subscriber databases are SQL
>Server 7 backups restored on a SQL Server 2000 Server. The
>Publication worked with no problem on the SQL Server 7
>server environment.
>
>Does anybody have any idea.
>
>Best regards
>
>Jakob Brøckner
>
>If possible please also post an answer directly to my
>email address.
>
>
>.
>

Relevant Pages

  • Re: Invalid object name: dbo.sysmergepublications
    ... if you get errors about missing objects create them like this create ... Then try to recreate it. ... Looking for a SQL Server replication book? ... publication, and also is not able to create a publication of another table. ...
    (microsoft.public.sqlserver.replication)
  • Re: Database context error when creating new publication
    ... Query Analyzer or SQL Management Studio's variant and see what the error is? ... when i create a new publication i'm getting this error: ... sqlCommand, ExecutionTypes executionType) ... exception, Boolean breakConnection) ...
    (microsoft.public.sqlserver.replication)
  • RE: Synchronisation failing on SQL CE Database
    ... There is also an error on the publication in the Replication monitor. ... Server SERVER, Level 0, State 1, Procedure sp_MSprepare_mergearticle, Line 78 ... I am having a problem setting up merge replication between SQL 2005 and SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication Publishing Subscriber Issue
    ... to by the SQL 2000 server, and then republished to the MS Access ... The first publication has a static ... filter based on a region value. ... The issue was that the MS Access subscriber would upload changes ...
    (microsoft.public.sqlserver.replication)
  • Re: Create new publication error
    ... replication passwords and enter the distributor sa account and password ... Looking for a SQL Server replication book? ... When I attempt to create a new publication, using either SSMS or EM, I ...
    (microsoft.public.sqlserver.replication)