Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication 2005 not replicating with filter clause

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top