Re: Error 207

From: Mary Bray (reply_at_tonewsgroup.com.NOSPAMPLEASE)
Date: 08/11/04 

Date: Thu, 12 Aug 2004 08:06:53 +1000

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: 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: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)