Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Update to replication pivot table.

Author  Topic  reggie61 Starting Member 1 Post Posted - 2006-05-30 : 14:39:58 Hi, My replication is setup in SQLServer 2005, the publication uses a pivot table (or so called by me) to filter a host of other tables in the publication. The ID from the pivot table is the FK/Filter to the joined tables. I have timeout issues while updating the pivot table and I suspect it has to do with the snapshot triggers trying to propagate the update for the whole publication in the same instant causing the update to the pivot table to timeout and fail. When the publication is dropped the update goes through in a breeze. I would appreciate any inputs/resolution/work-arounds. Thanks Reggie