November 18, 2004 at 10:33 am
Greetings, I am writing with a problem that I have not seen mentioned in any forums yet. We have a medium-sized OLTP environment which is replicated (using transactional replication) to a second server for reporting purposes. Recently, we implemented an Indexed View on one of our busiest (OLTP) tables. Immediately after doing this, we stopped receiving 'updates' from the OLTP system to the reporting server, only receiving inserts or deletes.
It seems that when indexed views are created on table, the LogReader sees updates only as delete/insert combination rather than the normal 'update', so the typical call (or mcall or xcall) to sp_MSupd_{Tablename} is never made. This would probably not have been noticed except that our synch method for 'delete' actions on this table is 'NONE' since we never delete data from the report server.
I have resolved the problem by rewriting the 'insert' method to automatically call the 'update' method when an attempt is made to insert a duplicate row. But i was wondering if anyone else has encountered this problem.
November 22, 2004 at 8:00 am
This was removed by the editor as SPAM
November 22, 2004 at 11:39 pm
I'm not sure if you have a partitioned view, but does this help?
http://support.microsoft.com/default.aspx?scid=kb;en-us;270013
If this doesn't help maybe try recreating the view anyway?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply