PZJ
Technical User
- Dec 10, 2007
- 1
We have just moved to SQL 2005.
In our SQL 2000 system we had 2 tables that were replicated, one using a filter clause. They both replicated on the target successfully.
Once we moved to SQL 2005 the table with the filter clause was not being replicated - we do not get any error messages.
This is the article script:
exec sp_addarticle @publication = N'JobsRecent', @article = N'JobsRecent', @source_owner = N'dbo',
@source_object = N'Jobs', @destination_table = N'Jobs_Recent', @type = N'logbased', @creation_script = null,
@description = null, @pre_creation_cmd = N'drop', @schema_option = 0x00000000000000F3, @status = 16,
@vertical_partition = N'true', @ins_cmd = N'CALL sp_MSins_Jobs_Recent',
@del_cmd = N'CALL sp_MSdel_Jobs_Recent', @upd_cmd = N'MCALL sp_MSupd_Jobs_Recent', @filter = null,
@sync_object = null, @auto_identity_range = N'false',
@filter_clause = N'Is_Valid = 1 AND DATEDIFF(D, Date_Updated, GETDATE()) < 8'
GO
In our SQL 2000 system we had 2 tables that were replicated, one using a filter clause. They both replicated on the target successfully.
Once we moved to SQL 2005 the table with the filter clause was not being replicated - we do not get any error messages.
This is the article script:
exec sp_addarticle @publication = N'JobsRecent', @article = N'JobsRecent', @source_owner = N'dbo',
@source_object = N'Jobs', @destination_table = N'Jobs_Recent', @type = N'logbased', @creation_script = null,
@description = null, @pre_creation_cmd = N'drop', @schema_option = 0x00000000000000F3, @status = 16,
@vertical_partition = N'true', @ins_cmd = N'CALL sp_MSins_Jobs_Recent',
@del_cmd = N'CALL sp_MSdel_Jobs_Recent', @upd_cmd = N'MCALL sp_MSupd_Jobs_Recent', @filter = null,
@sync_object = null, @auto_identity_range = N'false',
@filter_clause = N'Is_Valid = 1 AND DATEDIFF(D, Date_Updated, GETDATE()) < 8'
GO