Hello there,

I have pull type of replication setup. I see the error in Distribution
Agents as Invalid Column name "XXX" and the error number is 207.

Any ideas how I can troubleshoot this problem?

Paul,
Thanks for your time. The error message is Invalid column name 'TestDate'.

There are 5 desktop users set up for pull replication when they logout from
their work station at the end of the day. I am using SQL Server 2000 SP3a.
Please let me know if you need any more details. Below is the script of
entire publication if it helps you. I had to trim the script as it allows
only 30000 characters in a posting.

-- Enabling the replication database
use master
GO

exec sp_replicationdboption @dbname = N'BCPNet', @optname = N'publish',
@value = N'true'
GO

use [BCPNet]
GO

-- Adding the snapshot publication
exec sp_addpublication @publication = N'BCPNet-BCPNetLocal', @restricted =
N'false', @sync_method = N'native', @repl_freq = N'snapshot', @description =
N'Snapshot publication of BCPNet database from Publisher FAUSK400.', @status
= N'active', @allow_push = N'true', @allow_pull = N'true', @allow_anonymous =
N'false', @enabled_for_internet = N'false', @independent_agent = N'false',
@immediate_sync = N'false', @allow_sync_tran = N'false', @autogen_sync_procs
= N'false', @retention = 0, @allow_queued_tran = N'false',
@snapshot_in_defaultfolder = N'false', @alt_snapshot_folder =
N'\\fausk400\ReplData', @compress_snapshot = N'false', @ftp_port = 21,
@ftp_login = N'anonymous', @allow_dts = N'false', @allow_subscription_copy =
N'false', @add_to_active_directory = N'false'
exec sp_addpublication_snapshot @publication =
N'BCPNet-BCPNetLocal',@frequency_type = 4, @frequency_interval = 1,
@frequency_relative_interval = 1, @frequency_recurrence_factor = 0,
@frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date =
0, @active_end_date = 0, @active_start_time_of_day = 0,
@active_end_time_of_day = 235959, @snapshot_job_name =
N'FAUSK400-BCPNet-BCPNet-BCPNetLocal-6'
GO

exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'BCPReplicate'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\CKoebck'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\DBAdmins'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\JNAVARR'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\JWellbo'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\MSSQLService'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\SQLBCPBIZNET'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'CORP\SQLREPLSERVICE'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'NT Authority\System'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'sa'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'SQLReplication'
GO
exec sp_grant_publication_access @publication = N'BCPNet-BCPNetLocal',
@login = N'TPGApp'
GO

-- Adding the snapshot articles
exec sp_addarticle @publication = N'BCPNet-BCPNetLocal', @article =
N'tblBUPlan', @source_owner = N'dbo', @source_object = N'tblBUPlan',
@destination_table = N'tblBUPlan', @type = N'logbased', @creation_script =
null, @description = null, @pre_creation_cmd = N'drop', @schema_option =
0x00000000000000F1, @status = 0, @vertical_partition = N'false', @ins_cmd =
N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL', @filter = null, @sync_object =
null, @auto_identity_range = N'false'
GO



[quoted text, click to view]