Error 207

Hi everyone,
I am trying to create a Transactional Pull Subscription=20
but I get an error 207 : Invalid column=20
name "enabled_for_syncmgr"
Invalid columnname "alt_snapshot_folder"
Invalid columnname "dts_package_name".
Both The Publication and Subscriber databases are SQL=20
Server 7 backups restored on a SQL Server 2000 Server. The=20
Publication worked with no problem on the SQL Server 7=20
server environment.
Does anybody have any idea.
Best regards=20
Jakob Br=F8ckner
If possible please also post an answer directly to my=20
email address.
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 Brckner" <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 Brckner
If possible please also post an answer directly to my
email address.
|||I have already recreated the publication with same error.
/Jakob Br=F8ckner
>--Original Message--
>I think your best idea is to recreate the publication -=20
SQL 2000 is sending
>some new parameters that were not around in SQL 7
>"Jakob Br=F8ckner" <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=F8ckner
>If possible please also post an answer directly to my
>email address.
>
>.
>
|||It seems I have solved the problem. The problem was that the tables :
MSsubscription_properties
MSreplication_subscriptions
Have a different design in SQL Server 2K than in SQL Server 7. And these
tables was also restored. And the sp_addpullsubscription_agent tries to
insert into these tables and some fields are missing or have different names.
But the sp_addpullsubscription_agent does not drop and recreate the table
for obvious reasons. But I dropped them through Query Analyser since you are
not allowed to drop System tables through Enterprise manager. But usiing :
DROP TABLE MSsubscription_properties
DROP TABLE MSreplication_subscriptions
and then trying to pull the subscription solved the problem.
/Jakob
"Jakob Br?ckner" wrote:

> I have already recreated the publication with same error.
> /Jakob Br?ckner
> SQL 2000 is sending
>